How can we help you today? How can we help you today?

Bug with TO_DATE function

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
larus
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    Do you have the DDL for the (source and target) objects that cause this behavior?
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.