Loading...

cfaussie@googlegroups.com

[Prev] Thread [Next]  |  [Prev] Date [Next]

RE: [cfaussie] MySQL - date insertion issues. Dale Fraser Wed Jul 20 00:00:11 2011

Do this

#createodbcdatetime(createDate(mid(form.datelisted, 7, 4),
mid(form.datelisted, 4, 2), mid(form.datelisted, 1, 2))#<

Dale

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Gavin Baumanis
Sent: Wednesday, 20 July 2011 12:05 AM
To: cfaussie
Subject: [cfaussie] MySQL - date insertion issues.

Hi Everyone,

I have the following code;

form.date : #form.datelisted#<br />
LSDATEFORMAT : #lsdateformat(form.datelisted, 'YYYY-MM-DD')#<br />
DATEFORMAT : #dateformat(form.datelisted, 'YYYY-MM-DD')#<br />
CREATEODBCDATE : #createodbcdate(form.datelisted)#<br /> CREATEODBCDATETIME
: #createodbcdatetime(form.datelisted)#<br />

Which outputs the following;

form.date : 01/03/2011
LSDATEFORMAT : 2011-01-03
DATEFORMAT : 2011-01-03
CREATEODBCDATE : {d '2011-01-03'}
CREATEODBCDATETIME : {ts '2011-01-03 00:00:00'}

My question is why are my month and day parts of my date being transposed?
How do I stop it from being so?

The date that should be inserted into the database is the 1st of March, not
3rd January.


As always - Thanks!

Gavin.

--
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.