Bug with TO_DATE function

Compares and synchronizes the schemas of Oracle databases

Bug with TO_DATE function

Postby larus » Mon Dec 09, 2013 2: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: 9
Joined: Thu Sep 16, 2010 12:32 pm

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

Thanks for your post.

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

Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests