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

  • April 17, 2014 at 10:49 am

    #1706862

    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??