Incorrect datetime value: '2022-01-24T20:52:00.000Z' for function str_to_date

[AJM2]

Error: INSERT INTO weather_data (datetime, temp, feelslike, stationbarometer, sealevelbarometer, dewpoint, humidity, winddir, windspeed, gust, maxdailygust, hourlyrainrate, dailyrain, weeklyrain, monthlyrain, totalrain, lastrain, solar, battout) VALUES ( STR_TO_DATE('2022-01-24T20:52:00.000Z' , '%c-%e-%Y %T'), 49.1, 49.1, 29.959, 29.135, 47.16, 93, 274, 0.7, 1.1, 8.1, 0, 0.181, 0.181, 0.701, 49.043, STR_TO_DATE('2022-01-24T19:22:00.000Z', '%c-%e-%Y %T'), 57.62, 1 )
Incorrect datetime value: '2022-01-24T20:52:00.000Z' for function str_to_date 

WTF is up with dates in mysql? I haven't worked in it since version 5.* but I never had the problems I am having trying to insert.

Any help would be greatly appreciated.

 

[requinix]

Look at the query.

STR_TO_DATE('2022-01-24T20:52:00.000Z' , '%c-%e-%Y %T')

What will that try to do?

[AJM2]

Finally! I switched one field to timestamp and generate on insert. I also switched the lastrain date to a string since it comes in as a string.

It is inserting every time the page is hit. So getting closer.

[AJM2]

Thanks reqinix. I did try that, as well as several other formats. I am not sure why it wasn't taking it. See my last, I have it figured out.

 

[requinix]

If the field is a date then it should be a date. Don't make it a string.

But what I was trying to point out was that you were asking MySQL to interpret the timestamp 2022-01-22T20:52:00.000Z according to the format %c-%e-%Y %T, or in other words M-D-YYYY HH:MM:SS. That's not going to work.