Mariadb V10.5.23. Datebase stored is a DateAndTime column with these value: “2024-08-13T04:0t0:00.000Z”
Using STR_TO_DATE(DandAndTime,’%Y-%m-%d’)
yields the folowing: DateAndTime: “2024-08-13T13:07:04.000Z”
Date: “2024-08-13T04:00:00.000Z”
There is no change.
I’m expecting “2024-08-13”.
What am I doing wrong.