I always try and use 3-mar-2011 style date formats as it avoids any of the month issues, but using the locale and Ls* functions is the most robust approach
On Wed, Jul 20, 2011 at 1:49 PM, Dale Fraser <[email protected]> wrote: > 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. > > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 -- 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.
