time_t and to_date conversions

• steven jackson

  SSC Veteran

  Points: 292

  More actions

  November 5, 2002 at 12:30 pm

  #101294

  I have a time_t date in a character field (time in seconds since 1/1/1970) that I need

  to tranlsate to use in a query. I know how to do it in Oracle with to_date but no idea in transact SQL. Does anyone have ideas/examples? How is a to_date done in SQLSERVER? Thanks Steven

  sjackson@hq.dcma.mil

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  November 5, 2002 at 2:03 pm

  #440393

  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

  November 5, 2002 at 2:35 pm

  #440401

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

• steven jackson

  SSC Veteran

  Points: 292

  More actions

  November 5, 2002 at 2:37 pm

  #440404

  THANKS!!!!