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:252690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4