Skip to Main Content
Forums

Oracle Database Discussions

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!

Current_Timestamp with microseconds or nanoseconds

537198Oct 3 2006 — edited Oct 4 2006
Hi,

I need help to format current_timestamp with more than 3 decimal digitis.
When i place SELECT CURRENT_TIMESTAMP(9) FROM DUAL; or CURRENT_TIMESTAMP without indicates the decimal digitis, because default is 6. But in my server returns 03/10/2006 08:45:25.381000000. If i test in other server the result is 03/10/2006 08:45:25.381542000.

I alter the NLS_DATE_FORMAT, TIME_ZONE, but nothing.

Please i need help you.

Thanks,
Carlos Pinheiro
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2006
Added on Oct 3 2006
#general-database-discussions
2 comments
542 views