Friday, 3 October 2014

Convert GMT Literal Time to Unix Seconds in SQL Server




CAST(DATEDIFF(SECOND,{d '1970-01-01'}, (CONVERT(VARCHAR,DATEADD(hh, DATEDIFF(hh, GETDATE(), GETUTCDATE()),[LL_DateTime]),126)+'Z')) as BIGINT) as upload_time,

No comments:

Post a Comment