Struggling to Insert date into Oracle Database using JDBC reciever
25-12-2014 10:52:09 is the format in which I am able to insert the values in the ORACLE 11g database. When I try to use DateTrans to insert the date in this format I am unable to do that as the reciever adapter Prompts : java.sql.SQLException: ORA-01843: not a valid month.
The work around which suggests using a TO_DATE in the constant, then passing the value '02-03-2015 16:29:00','dd-MM-yyyy hh:mm:ss' in the TO_DATE and mapping it with the target date field prompts another error :ORA-01858: a non-numeric character was found where a numeric was expected. I have passed hasQoute value as NO.
EDATUV gives me the date while EZEIT gives me the time.
Delivery date Queue
this should be the value in second constant.