Bug with TO_DATE function

laruslarus Posts: 15
edited December 10, 2013 11:02AM in Schema Compare for Oracle
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


Sign In or Register to comment.