Will the MySQL datetime format work with SQLite and PostgreSQL?

Question

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?

Answer 1

Yes for Postgres.

Answer 2

As Sqlite doesn't support different data types, yes you can definitely use it. iso-8601 dates have the big advantage that they sort lexically (unlike, for example, US dates)

Answer 3

SQLite uses several date formats; PostgreSQL uses similar formats and more.

Both understand YYYY-MM-DD HH:MM:SS.