When insert “2021-10-27” data on Spreadsheet to Date type cell on MySQL, following error occur.
As you can see from the error message, the original ”2021-10-27” has changed to ”2021-10-27T00:00:00-05:00”, this seems to be the cause of error.
If anyone knows how to solve this problem, could you please teach me?
----Error Message---
(pymysql.err.InternalError) (1292, "Incorrect date value: '2021-10-27T00:00:00-05:00' for column 'update_date' at row 1")
Best answer by robschmidt
View original