Skip to navigation
MsSql Unix time
26.03.14
--Convert Unix time 1282234070 to DateTime SELECT DATEADD(SECOND, 1282234070, {d '1970-01-01'}) --Convert DateTime GETDATE() to Unix time SELECT DATEDIFF(s, '19700101', GETDATE())
http://mac-blog.org.ua/mssql-unix-time/
Reply
Anonymous
Information Epoch 1732527504
Use lower case and keep it short.
Home
Notebook
Contact us