[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
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!


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