Database Timestamp Formatter

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

SQL formatting logic.

Target Date

Target Time

MySQL / MariaDBDATETIME / TIMESTAMP

'2026-02-26 20:48:05'

Standard SQL format without timezone.

PostgreSQLTIMESTAMP

'2026-02-26 20:48:05'

Without timezone indicator.

PostgreSQLTIMESTAMPTZ

'2026-02-26 20:48:05+05:30'

With timezone offset.

SQLiteTEXT (ISO8601)

'2026-02-26T15:18:05.000Z'

SQLite lacks native storage, relies on strings.

SQL ServerDATETIME2

'2026-02-26 20:48:05.000'

Higher precision capability.

OracleTIMESTAMP

'26-Feb-26 08.48.05.000000 PM'

Requires NLS_TIMESTAMP_FORMAT matching.

CassandraTIMESTAMP

'1772119085000'

Often stored directly as epoch milliseconds.

Overview

Avoid SQL syntax errors on insertion.