Bug with TO_DATE function

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Bug with TO_DATE function

Postby larus » Mon Dec 09, 2013 3:12 pm

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
Posts: 6
Joined: Thu Sep 16, 2010 1:32 pm

Postby Chris Auckland » Tue Dec 10, 2013 5:02 pm

Thanks for your post.

Do you have the DDL for the (source and target) objects that cause this behavior?
Chris Auckland
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest