Hi all, I am trying insert a record in to oracle table from cold fusion mx.One of the fields is a date/time field.It gives me an error.Below is the code.Please help. YY HH:MM:ss")> Insert into table1(name,ssn,datesubmitted,email) values('xxx','xxx-xxx-xxxx', TO_DATE('#submitdate#'...