date format fo mySql

2010-08-20 Thread Rob Voyle
Hi Folks I have a coldfusion variable expireDate=Dec. 10, 2010 That I want to insert as a date into a mySql database The table cell is set up as a date but I can't find the right cf date format to get the insert to work. I keep getting a syntax error. Thanks Rob Robert J. Voyle,

Re: date format fo mySql

2010-08-20 Thread Jim Eisenhauer
Is your field in the db set up as a DATE or DATETIME? Jim Eisenhauer On Fri, Aug 20, 2010 at 9:26 AM, Rob Voyle r...@voyle.com wrote: Hi Folks I have a coldfusion variable expireDate=Dec. 10, 2010 That I want to insert as a date into a mySql database The table cell is set up as

Re: date format fo mySql

2010-08-20 Thread Jim Eisenhauer
Where is the date you need to insert coming from as well? A form? and/or is it a literal string like 'Dec. 10, 2010'... or is the form field passing an actual date variable? Jim Eisenhauer On Fri, Aug 20, 2010 at 9:28 AM, Jim Eisenhauer eisenha...@gmail.comwrote: Is your field in the db set

Re: date format fo mySql

2010-08-20 Thread Rick Root
On Fri, Aug 20, 2010 at 12:26 PM, Rob Voyle r...@voyle.com wrote: Hi Folks I have a coldfusion variable        expireDate=Dec. 10, 2010 That I want to insert as a date into a mySql database The table cell is set up as a date but I can't find the right cf date format to get the insert

Re: date format fo mySql

2010-08-20 Thread Michael Grant
CreateODBCDate(expireDate) or CreateODBCDateTime(expireDate) On Fri, Aug 20, 2010 at 12:26 PM, Rob Voyle r...@voyle.com wrote: Hi Folks I have a coldfusion variable expireDate=Dec. 10, 2010 That I want to insert as a date into a mySql database The table cell is set up as a date

Re: date format fo mySql

2010-08-20 Thread rex
Rick is right. Use cfqueryparam and your problems will go away: INSERT INTO xTable(xDate) VALUES (cfqueryparam value=Dec. 10, 2010 cfsqltype=cf_sql_date /); That's for a DATE column. If you are doing a DATETIME column, use cf_sql_timestamp instead. Rick Root wrote: On Fri, Aug 20, 2010 at

Re: date format fo mySql

2010-08-20 Thread rex
wierd, my first reply didn't go through... Rick is right. Use cfqueryparam and your problems will go away: INSERT INTO xTable(xDate) VALUES (cfqueryparam value=Dec. 10, 2010 cfsqltype=cf_sql_date /); That's for a DATE column. If you are doing a DATETIME column, use cf_sql_timestamp