Unix Timestamp in SQL Server

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

Get the current timestamp

SELECT DATEDIFF_BIG(second, CAST('1970-01-01' AS datetime2), SYSUTCDATETIME());

Timestamp to date

SELECT DATEADD(second, 1700000000, CAST('1970-01-01' AS datetime2));

Date to timestamp

SELECT DATEDIFF_BIG(second, CAST('1970-01-01' AS datetime2),
                    CAST('2023-11-14T22:13:20' AS datetime2));

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 SQL Server 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 datetime2 UTC values and DATEDIFF_BIG to avoid overflowing a 32-bit seconds count. The example DATEADD uses an int argument, so split larger counts into days and seconds on older versions.