time formating for values greater than 23:59
398643Nov 26 2009 — edited Nov 26 2009hi 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