Loading...

cfaussie@googlegroups.com

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

[cfaussie] MySQL - date insertion issues. Gavin Baumanis Tue Jul 19 13:00:22 2011

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.