Re: Proper datetime format for insert
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.
Subject
Written By
Posted
Re: Proper datetime format for insert
August 01, 2022 05:52PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.