Is the column a date or a varchar - because you're using a varchar cfsqltype.
I usually use the Oracle to_date() function to insert a date/time. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/8/18 Ian Vaughan <[email protected]>: > > Hi > > I am trying to insert the current date and time into an Oracle db using > the following > > <cfqueryparam cfsqltype="cf_sql_varchar" value="#LSDateFormat(Now(), > "dd-mmm-yyyy")# #LSTimeFormat(Now())# > > > But I am getting the following coldfusion error from the database? > > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01830: date format picture > ends before converting entire input string > > Any ideas on what's going wrong? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
