How to Convert Epoch Time to Date in SQL

Published April 2025 · 3 min read

MySQL

SELECT FROM_UNIXTIME(1713000000);
-- 2024-04-13 12:00:00

PostgreSQL

SELECT TO_TIMESTAMP(1713000000);
-- 2024-04-13 12:00:00+00

SQL Server

SELECT DATEADD(s, 1713000000, '1970-01-01');
-- 2024-04-13 12:00:00

SQLite

SELECT datetime(1713000000, 'unixepoch');
-- 2024-04-13 12:00:00

Date to Epoch (Reverse)

-- MySQL
SELECT UNIX_TIMESTAMP('2024-04-13 12:00:00');

-- PostgreSQL
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2024-04-13 12:00:00');

Online Tool

Use our Unix Timestamp Converter for quick conversions.

Related