SQL Timestamp Converter

Convert any date to SQL TIMESTAMP / DATETIME format. Timezone-aware.

SQL Timestamp

2026-07-25 13:25:52

DATETIME / TIMESTAMP columns. No timezone info — ambiguous without context.

SQL Timestamp (UTC)

2026-07-25 17:25:52

Same format but always in UTC. Unambiguous when your DB stores UTC.

ISO 8601 Date

2026-07-25

DATE column format: YYYY-MM-DD

ISO 8601 (with offset)

2026-07-25T13:25:52-04:00

Timezone-aware alternative. Use when your DB supports TIMESTAMPTZ.

What is a SQL Timestamp?

SQL TIMESTAMP (or DATETIME) format is YYYY-MM-DD HH:MM:SS. It's the standard literal format for date/time values in SQL databases including PostgreSQL, MySQL, SQLite, and SQL Server. The format itself carries no timezone information — the interpretation depends on your database's timezone settings.

TIMESTAMP vs TIMESTAMPTZ

In PostgreSQL, TIMESTAMP stores a date/time without timezone (what you insert is what you get back). TIMESTAMPTZ stores the instant in UTC and converts to the session's timezone on retrieval. Best practice: always use TIMESTAMPTZ and store UTC values.

Database Syntax Examples

PostgreSQL

SELECT '2024-07-15 12:00:00'::timestamp;

MySQL

SELECT CAST('2024-07-15 12:00:00' AS DATETIME);

SQLite

SELECT datetime('2024-07-15 12:00:00');