Mysql UTC format works for "SELECT" but NOT for "UPDATE"

21 Views Asked by At

This is the columns "created_at" datatime enter image description here

And I can query "created_at" with a UTC time SELECT

But alert "Incorrect datatime value" while "UPDATE" UPDATE

I don't know, but for UPDATE command, I have to use a 'YYYY-MM-DD HH:MM:SS' format, and it works

But still makes no sense to me,

I believe the UTC is more accurate, and if "SELECT" could recognize UTC, why not "UPDATE"?

0

There are 0 best solutions below