Doug, You shouldn't need to worry about formatting the date for an insert into the database, instead format when you are retrieving the date for display.
On 9/9/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > figured it out. I guess mySql does not like dateFormat(now(),"mm/dd/yyyy) > and prefers dateFormat(Now(),"yyyy/dd/mm") Just some of the things I am > goping to have to get use to I suppose. > > The DATETIME type is used when you need values that contain both date and > time information. MySQL retrieves and displays DATETIME values in > 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' > to '9999-12-31 23:59:59'. > > > > ----- Original Message ----- > From: "Mr. Darby" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Saturday, September 09, 2006 6:35 PM > Subject: Re: datetime value for mySql > > > > Doug, > > > > What is the code you are using to perform the insert? > > > > > > On 9/9/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > > > > > what is the correct datetime format for mySql? I get an error on > insert > > > > > > Error Executing Database Query. > > > Incorrect datetime value: '09/09/2006 05:39 PM' for column > > > 'join_date' at row 1 > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4