Thanks to everyone. I already had the date formatting correct. I was using a perl script to generate the <cfstoredproc> for some reason it didn't like the date datatype in oracle and defaulted the cfsqltype to varchar. Changing the cfsqltype to date fixed the problem.
Thanks again, Frederic Tony Schreiber wrote: > Oracle needs to know exactly what date format your passing... > > You could use CF to format the date to default oracle format first: > > value="#DateFormat(date,'DD-MMM-YYYY')#" > > > I am using cf5 and <cfstoredproc> to insert a date/time into oracle 8i. I > f I > > pass only the date like this: > > <cfprocparam > > dbvarname="in_DATE_EVENT_END" > > cfsqltype="cf_sql_varchar" > > value="03-Jan-2002" > > type="in"> > > It works fine. but when I attempt to include the time as 03-Jan-2002 00: > 00 > > I get the following error > > ORA-01830: date format picture ends before converting entire input > > string ORA-06512: at line 1 > > anyone have any idea as to what I can do to insert a complete datetime > > value in oracle? > > > > Thanks in advance, > > Frederic > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
