Will the MySQL datetime format work with SQLite and PostgreSQL?
date, mysql, postgresql, sqlite
Solution
SQLite uses several date formats; PostgreSQL uses similar formats and more.
Both understand YYYY-MM-DD HH:MM:SS.
Problem
In MySQL you enter dates (`datetime` field) in the format `2009-10-16 21:30:45`. Which makes it simple to insert times into the database. ``` $date = date('Y-m-d H:i:s', $timestamp); ``` Will this format work with SQLite and PostgreSQL? If not, what format do they use?