Dear All,
I have a PHP POST variable containing a date in DD/MM/YYYY format string. How do I record this to a DATE field in a MySQL table? Do I have to break up the string using explode() and somehow write the day month and year numbers separately?
Many thanks
Mark
Input format for SQL dates
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Or you could convert it to the unix epoch time and store it as a int(10) field.
Or you could convert it to the unix epoch time and store it as a int(10) field.