Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Convert Bigint time to datetime RE: Convert Bigint time to datetime

  • April 21, 2014 at 7:25 am

    #1707442

    PSB (4/21/2014)

    According to the query time returned is 1970-03-12 19:15:49.000 .

    SELECT DATEADD(hh,-5,dateadd(s, convert(bigint, 6135349140000) / 1000000, convert(datetime, '1-1-1970 00:00:00')))

    The correct time that should be returned is 2014 -03-20 03:27:00.00

    Question: where does the reference date of 1-1-1970 come from, are you working with unix dates:

    Secondly, consider these numbers for an average year (365.25 days)

    8766Hours

    525960Minutes

    31557600Seconds

    😎