Working with Mysql-dateformat
Posted on 2004-08-13
On a form several dates can be filled in wich will be inserted into a Mysql-database (after pressing the submit-button). Now it seems (i never worked with Mysql before) that it stores the date in the yyyy-mm-dd format.
I want the form to hold the date in a dd-mm-yyyy format (when loading data into a form) and to be able to fill in a date like dd-mm-yyyy and still get it stored correctly. Anyone got an easy solution to this?
The form now looks like this:
<tr><td>Closing date:</td><td><input type="text" name="d_hd_close" size=14 maxlength=14 /></td></tr>