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!

How to show nanoseconds of a CURRENT_TIMESTAMP?

Zafar IqbalJan 20 2011 — edited Jan 20 2011

Hi,

I am using *10g database* on Microsoft Windows family OS

when i run following query

sql> SELECT CURRENT_TIMESTAMP FROM DUAL;

then i get result
20-01-2011 11:52:17.921000 AM +05:00

but i want to get result as
20-01-2011 11:52:17.921256 AM +05:00

is there any way to get up mentioned result.
i shall be very thank

thanks in advance

This post has been answered by Pierre Forstmann on Jan 20 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2011

Added on Jan 20 2011

#database, #general-database-discussions

6 comments

4,794 views