Re: Sum total of a time field
Rusty Wallace wrote:
> We have a table with a field of type TEXT storing the time for certain actions (ie. 0:30 - for 0
> mins 30 secs, 1:20:00 - for 1 hr 20 mins 0secs).
> We've come to a point where we'd like to sum the entire field up and get back the total time.
SELECT TIME_TO_SEC('1:20:00');
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: Sum total of a time field
July 13, 2005 12:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.