MySQL → PostgreSQL

Convert MySQL DATETIME to PostgreSQL timestamp

MySQL DATETIME stores a wall-clock value with no time zone. The matching PostgreSQL type is timestamp (without time zone); zero dates need special care.

What to know

• DATETIME → timestamp; the values transfer unchanged
• MySQL's '0000-00-00 00:00:00' is invalid in PostgreSQL and becomes NULL
• DATETIME(6) microsecond precision is preserved (timestamp keeps 6 digits)
• If your values are actually UTC instants, consider timestamptz after import

Before / after

CREATE TABLE orders (
  placed_at DATETIME(6) NOT NULL
);

CREATE TABLE orders (
  placed_at timestamp(6) NOT NULL
);

See the full type mapping table or all guides.