This is the correct format: yyyy-mm-dd hh:mm:ss
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, September 09, 2006 6:47 PM To: CF-Talk Subject: datetime value for mySql 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:252719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
