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

  • July 1, 2014 at 7:23 am

    #1726180

    Lynn Pettis (4/17/2014)

    PSB (4/17/2014)

    select DATEADD(Minute, 1397750400000, '1970-00-01')

    Getting an overflow error .

    Arithmetic overflow error converting expression to data type int.

    Yep, told you that would happen earlier.

    Now, what date and time does 1397750400000 represent??

    Give a look to http://www.sqlservercentral.com/scripts/TIMESTAMP/76877/

    By the way, I believe they are seconds, not minutes