SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CONVERTING SQL TO ORACLE DATE ISSUE

eced5b43-9709-4224-abd7-f24017b206eeOct 30 2014 — edited Oct 30 2014

i have to convert very large databases from sql to oracle and oracle is not liking the date styles from sql

my sql tables contain the following date styles:

1 date

`2`	`smalldate`

`3`	`datetime`

`4`	`datetime2`

i have tried converting them with the migrator tool in oracle sql developer to the following:

1 date

`2`	`timestamp`

however any table that has dates returns empty in oracle

i tried manually placing in 1 row for a test in the empty table and i get the following error:

Quote

One error saving changes to table "DBO_CDOTE470"."BRIDGE":
Row 1: ORA-01861: literal does not match format string
ORA-06512: at line 1

if i remove the dates in place it will commit -- with the dates it will not

dates i am passing:

`1`	`2005-05-26 13:02:23.0000000`

what it will only accept

`1`	`26-May-2005`

i cant just type in convert blah blah because the db's are over 3gigs

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2014

Added on Oct 30 2014

#sql-developer

2 comments

1,064 views