David Carrdcblogdev.hashnode.dev·May 31, 2017Mariabdb Avoid Invalid datetime format: when date is emptyWhen inserting records any columns with a datatype set to date which are empty will generate this error: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime The reason for this by default MariaDB’s sql mode has NO_ZERO_DATE which wo...200 readsAdd a thoughtful commentNo comments yetBe the first to start the conversation.
