How to get the current Unix timestamp in SQL

gistfile1.md

Get the current Unix timestamp (seconds from 1970-01-01T00:00:00Z) in SQL.

• MySQL: UNIX_TIMESTAMP()
• PostgreSQL: CAST(EXTRACT(epoch FROM NOW()) AS INT)
• MS SQL: DATEDIFF(s, '1970-01-01', GETUTCDATE())
• Oracle: (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - DATE'1970-01-01') * 86400

In case you want to get the value in millisecond instead of seconds in T-SQL you may use the following code

(cast(DATEDIFF(s, '1970-01-01', GETUTCDATE()) as bigint)*1000+datepart(ms,getutcdate()))

Please use DATEDIFF_BIG for MS SQL Server in order to not run into Year 2038 Problem

Thanks a lot

Thank you, that CAST to INT improves performance dramatically.