time_t and to_date conversions

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

Think something like this might work for you:

declare @t_time char(100)

set @t_time =86400

select dateadd(ss,cast(@t_TIME AS INT),CAST('1/1/1970' AS DATETIME))

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

steven jackson SSC Veteran Points: 292 More actions · Answer 2

SELECT DATEADD(s, open_date, '1 / 1 / 1970') AS conv_dt FROM table_name

steven jackson SSC Veteran Points: 292 More actions · Answer 3

SSC Veteran

Points: 292

November 5, 2002 at 2:37 pm

THANKS!!!!