SQL datetime to Unix timestamp converter
SQL datetime (YYYY-MM-DD HH:mm:ss) → Unix timestamp in seconds
Unix timestamp · Unix Timestamp (sec)
No time zone in the value: read as UTC.
Worked examples
| Instant | SQL datetime | Unix timestamp |
|---|---|---|
| an ordinary afternoon | 2026-06-29 14:30:00 | 1782743400 |
| a leap day | 2028-02-29 09:05:07 | 1835427907 |
| the Unix epoch | 1970-01-01 00:00:00 | 0 |
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
Related conversions
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.