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.(207
000).
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...