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!

Datatype format

Annamalai ADec 22 2011 — edited Dec 22 2011

Hi,

Can any one help on this, i want to retrive the data from order_details table but that table contain the column having datatype with INTERVAL DAY(9) TO SECOND(6)), the result of the select query is,

+000000000 00:00:00.171000 but i want get the value like only 00:00:00 hr/mm/sec only can you please guide me how to get the values hh/mm/ss from INTERVAL DAY(9) TO SECOND(6))?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2012

Added on Dec 22 2011

9 comments

1,006 views