MySQL Forums
Forum List  »  Newbie

Re: Proper datetime format for insert
Posted by: Barry Galbraith
Date: August 01, 2022 05:52PM

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.

Options: ReplyQuote


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.