Re: Need query help to create intervals

[Peter Brawley]

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.