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:325519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4