Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to obtain the actual numerical value of the TIMESTAMP MINVALUE or TIMESTAMP MAXVALUE Keyword

User_M80CRMay 19 2021

Hello Team,
In the SELECT statement for FLASHBACK VERSION QUERY, one can successfully use
"VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE"
clause.
I am looking for some way to obtain the numerical value of the TIMESTAMP MINVALUE or TIMESTAMP MAXVALUE keywords using SELECT TIMESTAMP MINVALUE FROM DUAL like syntax or some other way if possible.
Please help if it is possible to view the actual numeric value of these keywords.
Timestamp_MInvalue.jpgTimestamp_MInvalue1.jpgBest Regards

This post has been answered by Paulzip on May 19 2021
Jump to Answer
Comments
Post Details
Added on May 19 2021
1 comment
230 views