Home Forums SQL Server 2005 SQL Server 2005 Strategies Convertion of integer to Datetime format RE: Convertion of integer to Datetime format

  • August 18, 2009 at 2:55 am

    #1040680

    At a guess , that is the number of seconds from 01jan1970

    try this

    select (1231151827/60)

    select 20519197/60

    select 341986/24

    select dateadd(dd,14249,'19700101')


    Clear Sky SQL
    My Blog[/url]