MySQL Forums
Forum List  »  Newbie

Re: Need query help to create intervals
Posted by: Peter Brawley
Date: August 17, 2022 10:02AM

Please provide Show Create Table result for your table, and note that MySQL date/datetime/timestamp columns do not understand the oddball mm/dd/yyyy US date format---they only read & write the international yyyy-mm-dd format. If users or input apps are married to US date format, you'll need to use str_to_date() to transform them into usable date values.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need query help to create intervals
August 17, 2022 10:02AM


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.