Alvin's Big Data Notebook
There are no rules, just tradeoffs
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment