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!

TIMESTAMP with nano seconds problem

57351Jun 20 2005 — edited Jun 21 2005

Hi there,
Can someone help on the following ?

select systimestamp(9) from dual, always returns timestamp values with the last 3 digits of nanoseconds equals to 000.

SQL> select systimestamp(9) from dual;

SYSTIMESTAMP(9)
----------------------------------
05.06.15 15:39:26,606662000 +01:00

SQL> select systimestamp(9) from dual;

SYSTIMESTAMP(9)
----------------------------------
05.06.15 15:39:30,280257000 +01:00

Thank you in advance.
Best Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2005

Added on Jun 20 2005

#general-database-discussions

3 comments

574 views