SQL DateTime Format — MySQL, PostgreSQL, SQLite | tick.pro
SQL datetime format reference for MySQL, PostgreSQL, and SQLite. Convert between database datetime formats and Unix timestamps.
Current SQL DateTime
--
Database Formats
MySQL DATETIME
2024-01-15 10:30:00
PostgreSQL TIMESTAMP
2024-01-15 10:30:00+00
SQLite TEXT
2024-01-15T10:30:00.000Z
Frequently Asked Questions
What datetime format does MySQL use?
MySQL uses YYYY-MM-DD HH:MM:SS format for DATETIME and TIMESTAMP columns. PostgreSQL supports ISO 8601 format with timezone awareness.
curl https://tick.pro/formats/sql-datetime