Anyone know if a date can be input as mm/dd/yyyy in mysql db.
I have a csv file i'm loading and all the dates are mm/dd/yyyy.
And once I get then input I need to select all records within the last 90 days.
Thanks
Not directly, you need to run the dates through the date formatting function.
Incorrect, if you have a column type of date, you can insert date like 2001/08/17 into the column, the db will reformat them to be MySQL compliant for you.
See the manual for more http://mysql.he.net/documentation/mysql/bychapter/manual_Reference.html#DATETIME
Ok,
I have a csv file with date format 8/17/2001.
Is there anything that can be done with this?
