Skip to content

Instantly share code, notes, and snippets.

@rsim

rsim/gist:d11652a8336137832df9

Created April 7, 2015 08:01
Show Gist options
  • Save rsim/d11652a8336137832df9 to your computer and use it in GitHub Desktop.
Save rsim/d11652a8336137832df9 to your computer and use it in GitHub Desktop.
Download ZIP
How to get the current Unix timestamp in SQL
Raw
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
@boogiefromzk
Copy link

boogiefromzk commented Jul 31, 2024

Thank you, that CAST to INT improves performance dramatically.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment