Solved

Convert UK date/time to MYSQL format.

Posted on 2003-10-23
2
466 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
Comment Utility
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
Comment Utility
Please ask Customer Service to PAQ this question for you so you can get your points back.

CJ
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 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

14 Experts available now in Live!

Get 1:1 Help Now