Convert UK date/time to MYSQL format.

MoOTottle
MoOTottle used Ask the Experts™
on
hi lads,

basically i want to convert a form field containing a date in the format:

31-12-2003 23:59:59

into this format

2003-12-31 23:59:59

any ideas? thanks :)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
job done.

<cfset currentdate=Now()>
<cfset currentdate=DateFormat(currentdate, "yyyy-mm-d h:m:s")>
<cfoutput>#Currentdate#</cfoutput>

Commented:
Please ask Customer Service to PAQ this question for you so you can get your points back.

CJ

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial