Solved

Coldfusion MySQL Date Issue

Posted on 2004-09-23
11
260 Views
Last Modified: 2013-12-24
Okay, heres all the facts to make sure things are understood. I live in Australia, so date format is dd/mm/yyyy. I ensure that the date format is dd/mm/yyyy for entry purposes, but then in the sql I enter #DateFormat(form.datefield,"yyyy-mm-d"). As long as my date is any day over 12 it puts it into the MySQL database properly. If for example, I enter 10/09/1979 (10th of September 1979) it will for some reason swap the month and the day so that its 09/10/1979 in mysql. However if I enter 25/09/1979 it enters it into the database as 25/09/1979. Any ideas? Whatever it is doing, it happens either in #Dateformat(form.datefield,"yyyy-mm-d") or in MySQL.
0
Comment
Question by:wulfshayde
  • 3
  • 2
  • 2
11 Comments
 
LVL 21

Accepted Solution

by:
pinaldave earned 100 total points
Comment Utility
try this #createodbcdate(DateFormat(form.datefield,"yyyy-mm-d"))#
0
 
LVL 4

Author Comment

by:wulfshayde
Comment Utility
Okay, Ive just noticed that its the coldfusion dateformat doing it, it error'd on that and showed the date as 1979-10-09 even though I entered it in as 10/09/1979(d/mm/yyyy)
0
 
LVL 4

Author Comment

by:wulfshayde
Comment Utility
Skip it, it was something stupid. I needed to use LSDateFormat rather than DateFormat. Can I give 100 points to pinaldave for his help and have the rest of my point PAQ'd?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 21

Expert Comment

by:pinaldave
Comment Utility
Hi wulfshayde,
yes you can do this. you have to post question in the  community support http://www.experts-exchange.com/Community_Support/
Regards,
---Pinal
0
 
LVL 17

Assisted Solution

by:Tacobell777
Tacobell777 earned 100 total points
Comment Utility
actually the best bet is to ALWAYS use createDate() it creates a date object that every function understands and no locale issues...

Where in Oz are you?
Im in Brisbane...
0
 
LVL 17

Expert Comment

by:Tacobell777
Comment Utility
This will also assist you if you ever need to convert the website to use other locales, like US etc..

I am working on a HP site that needs to support multiple languages (locales) and I convert every date to a date object with createDate( year, month, day )
0
 
LVL 4

Author Comment

by:wulfshayde
Comment Utility
@Tacobell777

I am in Darwin and Working on the Perkins Shipping Intranet site. I'll check out CreateDate today, thanks for the heads up, that could save me loads of time.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

763 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

9 Experts available now in Live!

Get 1:1 Help Now