?
Solved

Convert UK date/time to MYSQL format.

Posted on 2003-10-23
2
Medium Priority
?
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month10 days, 22 hours left to enroll

770 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