Hmmmm. Works fine for me.
Code:Personal Oracle Database 10g Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> SELECT current_timestamp - TRUNC (current_timestamp) time 2 FROM dual; TIME ----------------------------------------------------------------------- +000000000 14:53:04.941000 SQL>




Reply With Quote