Solved

Convert UK date/time to MYSQL format.

Posted on 2003-10-23
2
469 Views
Last Modified: 2013-12-24
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 :)
0
Comment
Question by:MoOTottle
2 Comments
 

Accepted Solution

by:
MoOTottle earned 0 total points
ID: 9605532
job done.

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

Expert Comment

by:cheekycj
ID: 9606016
Please ask Customer Service to PAQ this question for you so you can get your points back.

CJ
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now