1292 MySQL Origin: Data Last updated 12 Oct 2026

MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y'

A string couldn’t be converted to DATE/DATETIME — wrong format, empty string, or a zero date in strict mode.

Exact message you may see Incorrect datetime valueIncorrect date valueTruncated incorrect DOUBLE value
Explore the map of this error Full error map →
Seen on: MySQL

Meaning

MySQL expects 'YYYY-MM-DD HH:MM:SS'. ISO strings with T/Z, '' and '0000-00-00' fail in strict mode. Also “Truncated incorrect DOUBLE value” is 1292 for numeric conversions.

Common causes

  • ISO 8601 with T and Z (2024-01-01T10:00:00Z)
  • Empty string instead of NULL
  • Locale formats (31/12/2024)
  • Zero dates

⚡ Quick fix

  1. Format as Y-m-d H:i:s
  2. Send NULL instead of ''
  3. Convert ISO strings in the application or with STR_TO_DATE

Detailed fix by platform

MySQL

  1. STR_TO_DATE('31/12/2024', '%d/%m/%Y')

How to diagnose

  1. Value — Exact string?
  2. Mode — Strict sql_mode?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1264 — MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1 (MySQL)12641366 — MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1 (MySQL)13661690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169022008 — ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting. (PostgreSQL)22008DateTimeParseException — java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2 (Java)DateTimeParseExceptioninvalid time value — RangeError: Invalid time value (JavaScript)invalid time valueinvalid_date — API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ) (API)invalid_dateinvalid_type — API Error: Invalid type — expected integer, received string (API)invalid_type1292

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.