Bug with TO_DATE function
larus
Posts: 15
When comparing Oracle schemas, the deployment wizard gives me an INSERT statement where for date columns TO_DATE function like this:
INSERT INTO SCH.rg_temp_1087916431_0(ACTIVATION_TIME) SELECT TO_DATE(activation_time);
and this generates an error
[Error] Execution (26: 320): ORA-01861: literal does not match format string
INSERT INTO SCH.rg_temp_1087916431_0(ACTIVATION_TIME) SELECT TO_DATE(activation_time);
and this generates an error
[Error] Execution (26: 320): ORA-01861: literal does not match format string
Comments
Do you have the DDL for the (source and target) objects that cause this behavior?