Inserting date into MySQL
Posted: Mon Oct 20, 2003 4:15 am
Okay, i have a form where user enter the date in this format DD-MM-YYYY.
This needs to get inserted into a date field in my database. But the date field is formatted YYYY-MM-DD.
Is there something a can do in the query to format the date correctly, or will i have to format it using PHP first?
Thanks
Mark
This needs to get inserted into a date field in my database. But the date field is formatted YYYY-MM-DD.
Is there something a can do in the query to format the date correctly, or will i have to format it using PHP first?
Thanks
Mark