unusual date format

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  September 3, 2009 at 4:06 am

  #137860

  I am writing a query to extract some data from an application. The dates are held in an unusual format eg. 1220438820 somehow equals to Year -2008 Month-9 Day-3 Hour -10 Minute-47. Is anyone aware of what this format is and how I can convert it ?

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 3, 2009 at 4:16 am

  #1048632

  Thats the number of seconds from 01-jan-1970.

  Select dateadd(ss,1220438820,'19700101')

  ---

  
  Clear Sky SQL
  My Blog[/url]