Percent Second Value

[Queyon]

How could I display the percent second value of sysdate in Oracle? Or any other way to get this value? I want to get the date format of YYYY.MM.DD-HH24:MI:SS.ss

[jmodic]

The lowest granularity in Oracle's DATE tadatype is 1 second, so you (at least presently,maybe 9i will change this) can only get your date up to the second. You can get some arbitrary number of hundredths of seconds by querying the view V$TIMER, but you can not directly connect this time to a date datatype, as seconds in date and hundreds of seconds in V$TIMER are not synchronized.

But with use of java or external procedures you can easily create the function that returns a timestamp with the granularity of OS timestamp, which is typicaly much lower.

[Queyon]

Thank you very much.
V$TIMER is exactly what I need.

[jmodic]

BTW, SYS.DBMS_UTILITY.GET_TIME will return you the same information as the query from V$TIMER.