Re: Newbie SQL question

Did you try looking at the TO_DATE function?

Format

SSSSS 		Seconds past midnight
SS		Second
MI		Minute
HH		Hour	etc.  

You might also try looking at nesting the TO_DATE, and TO_CHAR functions.

                TO_CHAR( To_date(Secs, SSSSS), HH:MM:SS )

purcell_at_iag.net wrote:
>
> I have a table with each record containing a number value representing
> seconds. I want to be able to sum all seconds and display it in the
> format HH:MM:SS for the summed number of seconds. The format needs to
> zero pad the hours, minutes and seconds if it is only 1 digit.
Received on Fri Nov 15 1996 - 00:00:00 CET