Home Forums SQL Server 2005 T-SQL (SS2K5) Need help conveting this from Mysql to SQL server RE: Need help conveting this from Mysql to SQL server

  • December 19, 2012 at 1:28 pm

    #1570293

    dont forget to use

    dateadd(s, 875996580, '1/1/1970') for from_unixtime.

    convert_tz function does not exist in sql server so best bet is using aux table or datetimeoffset datatype.

    Alex S