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!

Change format to NUMTODSINTERVAL

510084Sep 29 2008 — edited Oct 1 2008

SQL> SELECT NUMTODSINTERVAL(120001, 'SECOND') FROM dual;

NUMTODSINTERVAL(120001,'SECOND')
---------------------------------------------------------------------------
+000000001 09:20:01.000000000

Is there any I can change above format to below one without using substr or extract?

NUMTODSINTERVAL(120001,'SECOND')
---------------------------------------------------------------------------
+01 09:20:01

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2008

Added on Sep 29 2008

#general-database-discussions

6 comments

3,496 views