How do you convert to Time in SQL

[NKOS13]

1. l have a column which say AUDITTIME and the value for time is numeric like below:
AUDTTIME
8042131
8042131
8042131
12171217
13315139
12181989
12184103
7423235

This does not represents this format of time (13:45:62)If l manage to get the time in any type of user readable that would be perfect. l just want to convert the this format of time to a real readable time format (eg 13:45 or 13H45 62 sec)

 

[ousoonerjoe]

Assuming that the integer given represents number of seconds since midnight, the following should get you to where you need:

DECLARE @seconds int;
SET @seconds = 12171217;

SELECT DATEADD(second, @seconds, '20090101'),CONVERT(char(5), DATEADD(second, @seconds, '20090101'), 108);

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------