Easy way.. if insert just use SQL Server GetDate() time stamp. To your question.. CreateODBCDateTime doesnt always work well.. read it in some docs.. Do some like this if you still want to use it. <cfset CFdateTime=CreateDateTime(2002,05,05,10,15,15)> (y,m,d,h,m,s) <cfset ODBCDT=CreateODBCDateTime(DateTime)>
Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:25 PM To: CF-Talk Subject: Re: SQL Server Date Error > Al Everett wrote: >>>I'm getting this when writing a date to a datetime len 8 in SQL Server >> >> >>>2000 in a hosted environment: >>> >>>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error >>>converting datetime from character string. >>> >>>It returns the error on any valid dates in mm/dd/yy format. I have >>>several date fields in other places but they're OK. I've >>>tried with and without quotes. >> >> >> This may be a silly question, but did you put your string inside a >> CreateODBCDate() function? > I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell). > I have CF code to validate the date. And it works on our development > server. FYI, No quotes around the CreateODBCWhatever() functions ... You might also try using <cfqeuryparam> ... Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
