Monday, May 17, 2010

Unix time stamp to SQL Server DATETIME

Oh, again. I need to take pills or what.
To:
SELECT DATEDIFF(s, '19700101', GETDATE())
From:
SELECT DATEADD(s, GETDATE(), '19700101')

No comments:

Post a Comment