Skip to content

SQL datetime to Unix timestamp converter

SQL datetime (YYYY-MM-DD HH:mm:ss) → Unix timestamp in seconds

Unix timestamp · Unix Timestamp (sec)

1656510331

No time zone in the value: read as UTC.

Worked examples

InstantSQL datetimeUnix timestamp
an ordinary afternoon2026-06-29 14:30:001782743400
a leap day2028-02-29 09:05:071835427907
the Unix epoch1970-01-01 00:00:000

What this conversion changes

  • Unix timestamp has no time zone of its own: the input is read as UTC unless it carries an offset, then counted in seconds from the Unix epoch.

SQL datetime — SQL datetime (YYYY-MM-DD HH:mm:ss)

Pattern
YYYY-MM-DD HH:mm:ss
Example
2022-06-29 13:45:31
Seen in
MySQL DATETIME, PostgreSQL timestamp, SQLite, CSV exports from databases

Unix timestamp — Unix timestamp in seconds

Pattern
Unix Timestamp (sec)
Example
1719619200
Seen in
Linux and Unix tools, PHP time(), Python time.time(), JWT exp/iat claims, Stripe and most payment APIs

Thousands of values to convert?

CSV batch mode converts an entire column from SQL datetime to Unix timestamp (or any of the 82 formats, with time-zone shifts), entirely in your browser, with no row limit set by us (your device's memory is the practical ceiling). $9.99/month, hides the ads, cancel anytime.