date format and sort questions

[Ryan Bauer]

Hello I am very new to mysql and have a quick question. I have a table set up a events section of a project I am working on. there are three different fields for the date one for Year, month and day. After doing some research I think I set up the fields wrongs I believe the date should only be in one field.
My question is can I still sort by date with the current format and what ould be the code to do this. or do I need to drop the three fields and replace it with one field for the entire date. If there is only one field how should the user input the date format like this yyyy/dd/mm or yyyy-dd-mm. I know this is simple but I cannot seem to find a straight answer. can anyone please help.



Edited 1 time(s). Last edit at 06/08/2009 11:35AM by Ryan Bauer.