Converting an Integer (in seconds) into a Date Value

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  May 24, 2005 at 8:28 am

  #362735

  I have a SQL Server Table (SQL Server 2000) which stores a date as an Integer Value. The Integer Values are like: 1099667378, 1099668505 and 1101155166. I was told that these values represent the Total Number of Seconds from a specified point in time (i.e., 1900 or 1970). Is there a SQL Date Function that would convert the Total Number of Seconds into a readable Date Format? Or do I need to create a formula that would: 1) Divide the Total Number of Seconds by 3600 to get the Total Number of Hours, 2) Then divide the Total Number of Hours by 24 to get the Total Number of Days, 3) Then use DateAdd to add the Total Number of Days to the Starting Point in Time, etc. Does anyone have a formula that would perform this conversion?

  Thanks in advance for you assistance, Kevin

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 24, 2005 at 8:33 am

  #560772

  SELECT DATEADD(s, integer_value, '1970-01-01')

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/