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

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

Sorry, you can't reply to this topic. It has been closed.

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.