Oracle date migration

Post a reply

Confirmation code
Enter the code exactly as it appears. All letters are case insensitive.
:D :) :( :o :shock: :? 8) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen:
BBCode is OFF
Smilies are ON
Topic review

Expand view Topic review: Oracle date migration

Re: Oracle date migration

Post by Support Team » Tue Aug 09, 2011 11:13 am

Try to open settings window and select to_date function from "Apply date conversion function" drop-down menu.
Of course, you should correct date and/or time format if necessary. The predefined format is 'YYYY-MM-DD HH24:MI:SS'

Oracle date migration

Post by Vik » Tue Aug 09, 2011 9:49 am

When I try to migrate the same table to Oracle it retrieves:

ORA-01861: literal does not match format string

Please help.