SQL Server Performance

Unix Date Conversion

Discussion in 'General Developer Questions' started by lkeerthi, Feb 1, 2005.

  1. lkeerthi New Member

    I would like to convert Unix Date time to Sql Date Time Stamp,
    and i am using dateadd function like dateadd(ss, myUnixDate - 18000, '19700101').
    However for some date time, i'm getting an hour difference randomly.

    Can you pls help to get correct date time stamp ?.
    Thanks forla all u r time.


Share This Page