Skip to Main Content

SQL & PL/SQL

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!

Precision In TIMESTAMP

mennanFeb 2 2007 — edited Feb 3 2007
Hi all;

I know timestamp data types has up to 9 precison after seconds.(Ref: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm)
SQL> SELECT systimestamp FROM dual;

SYSTIMESTAMP
-------------------------------------------------
02-FEB-07 02.26.51.207000 PM +02:00

SQL> 
BUt above query has 6(default for timestamp precision) digits and after 3 digits they become zero.(207000).

What i need is to display timestamp exactly 9 digits:
SQL> SELECT systimestamp FROM dual;

SYSTIMESTAMP
-------------------------------------------------
02-FEB-07 02.26.51.207569782 PM +02:00

SQL> 
Are there any ALTER SESSION command or any others to achieve this situation?

Thanks, Regards...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2007
Added on Feb 2 2007
13 comments
5,544 views