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. keerthi [?]