Posted on 2003-11-11
I'm using a MySQL database and I'm trying to insert a date into it using a web form in the format DD/MM/YY (UK style) 01/11/03 - 1st Novmeber 03.
When I insert a date using a form I use the following code:
<cfqueryparam value="#FORM.APPLY_BY#" cfsqltype="cf_sql_timestamp">
But when I display the value on a web page, I find that the database has inserted my date as MM/DD/YY (US Style) 01/11/03 - 11th January 03.
How can I change the insert code, so that it can be inserted DD/MM/YY?
Thanks in advance