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 > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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