Webmaster Forum / ColdFusion / Advanced Techniques / September 2005

The server throw this err: I am using cf mx server with oracle db
The err:
Error Executing Database Query.[Macromedia][Oracle JDBC
Driver][Oracle]ORA-01843: not a valid month The specific sequence of files
included or processed is: D:\CFusionMX\wwwroot\CEAF\CEAFProc.cfm

my insert statement is:
 Either one of them cause the err
to_date(#createodbcdate(Form.submitDate)#,'dd/mm/yy')  OR  
'#DATEFORMAT(Form.submitDate, 'DD-MMM-YYYY')#' OR
#createodbcdate(Form.submitDate)#