DATETIME functions

[bstacy1]

Hello all, I hope someone can help answer this question.

I have a field containing a number value for seconds. For example:

Employee BreakTime
---------- ----------
JohnDoe 1800

Is there a function that can be utilized in a query that would allow me to convert the 1800 seconds into a value showing hours/minutes/seconds such as:

00:30:00

Is something like this possible? If so can anyone help point me in the right direction?

Thanks,

 

[VDavid]

If there is only one function, i don't know it, but a way to do it could be:

select seconds(convert(time,'00:00:00.000'),BreakTime) from Table

Hope this helps,

David.

 

[solofeng]

hi bstacy1

this is a key:
hour:min:sec
hour:BreakTime/3600
minBreakTime-hour*3600)/60
secBreakTime-(BreakTime/60)*60))