Unix Timestamp in SQLite

Look up the current epoch time and convert between Unix seconds and UTC dates in SQLite.

Get the current timestamp

SELECT unixepoch();

Timestamp to date

SELECT datetime(1700000000, 'unixepoch');

Date to timestamp

SELECT unixepoch('2023-11-14T22:13:20Z');

Open 1700000000 in the converter

Current Unix time

Seconds—

Milliseconds—

UTC: —
My time zone: —

Official reference ↗

Free to use. Your input stays in this browser.

How to use it

Copy the current-time example into your SQLite environment to read Unix seconds.
Run the second example to display 1700000000 as a UTC date.
Run the last example to convert that date back into seconds.

Use the unixepoch modifier to make datetime read numeric input as epoch seconds. The auto modifier can interpret early-1970 timestamps as Julian day numbers.