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!

time formating for values greater than 23:59

398643Nov 26 2009 — edited Nov 26 2009
hi all
I have the following problem:
in my database I am storing schedules of buses in time stamp formats. If we assume, at trip starts at a stop station at 23:59 and ends the successive day at 00:10, than this value has the successive day.
So far so good.
Now I would like to export that table in a specific format, where only hours, minutes and seconds are relevant. Is there now a way to tell to oracle to save that value instead of 00:10 as 24:10?

many thanks for your help

Markus

Edited by: markusin on Nov 26, 2009 5:23 AM
This post has been answered by Solomon Yakobson on Nov 26 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2009
Added on Nov 26 2009
10 comments
1,084 views