Is the data field in the DB one of date or time? Seems to be the best thing to do is format it in the SELECT you're using so that it can be received as expected.

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format (though perhaps you thought of this and it's not in scope atm)

If the field is not of a date column, then you may wish to fix that with a one time script (after you fix this issue and figure _that_ part out). And make sure whatever is INSERTing the data does so in a way that is recognizable as a valid date to the DB.