Re: Sysdate time-resolution ?

Alexander Moan wrote:
>
> -snip-
>
> Is it possible to get 100.s and 1000.s of a second out of to_char or anyting
> else ?
>
> Alexander Moan --:-) moan_at_sn.no

I stole this from someone who stole it from someone else. You should be able to modify it to your needs.

SQL> select to_char(sysdate,'DD-MON-YYYY hh24:mi:ss:' ) || mod(hsecs,100) from v$timer;  

TO_CHAR(SYSDATE,'DD-MON-YYYYHH24:MI:SS.')||MOD(HSECS,100)

"The secret to creativity is knowing how to hide your sources."

                               Albert Einstein