Will MySQL datetime format work with SQLite and PostgreSQL?

Question

In MySQL, you enter dates ( datetime) in a format 2009-10-16 21:30:45. This makes it easy to insert time 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

SQLite uses several date formats ; PostgreSQL uses similar formats , etc.

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

Answer 2

Yes for Postgres.

Answer 3

Sqlite , , . iso-8601 , ( , , )