Skip to content

Instantly share code, notes, and snippets.

@rsim

rsim/gist:d11652a8336137832df9

Created April 7, 2015 08:01
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • 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
@Danipulok
Copy link

Thanks a lot

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