Database Timestamp Formatter

Format dates precisely for MySQL, PostgreSQL, and SQLite ingestion.

Target Date

Target Time

MySQL / MariaDBDATETIME / TIMESTAMP

'2026-03-17 07:59:10'

Standard SQL format without timezone.

PostgreSQLTIMESTAMP

'2026-03-17 07:59:10'

Without timezone indicator.

PostgreSQLTIMESTAMPTZ

'2026-03-17 07:59:10+05:30'

With timezone offset.

SQLiteTEXT (ISO8601)

'2026-03-17T02:29:10.000Z'

SQLite lacks native storage, relies on strings.

SQL ServerDATETIME2

'2026-03-17 07:59:10.000'

Higher precision capability.

OracleTIMESTAMP

'17-Mar-26 07.59.10.000000 AM'

Requires NLS_TIMESTAMP_FORMAT matching.

CassandraTIMESTAMP

'1773714550000'

Often stored directly as epoch milliseconds.