Re: Proper datetime format for insert

[Barry Galbraith]

Check MySQL manual
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html

Quote

Although MySQL tries to interpret values in several formats, date parts must always be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, '09-04-98', '04-09-98'). To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful.

Good luck,
Barry.