At 02:06 PM 25-10-01 +0000, you wrote:

>Dear All,
>
>I just joined this group. I'm in urgent need of knowing how to
>migrate data from Interbase to Oracle. I had tried by creating a
>script of the Interbase database by using EMS Quickdesk which pumps
>the data into a text file. But when I tried to run that file in
>Oracle, it created problems with date formats. Let me also mention
>that in that Interbase database there were different date formats for
>eg. in dd.mm.yyyy and dd.mm.yyyy hh:mm:ss. So this is what caused
>problems. Can somebody please help me out?

A quick answer here but if you have any further questions, please take them to the ib-support list ( http://www.yahoogroups.com/group/ib-support ). This is NOT a support list.

dd.mm.yyyy is the translation of a DATE type. dd.mm.yyyy hh:mm:ss is the translation of a TIMESTAMP type. Both types are stored as doubles, so what you are seeing in the output here are literal translations. InterBase has several literal translation formats available. Perhaps you need to find an export tool that gives you a choice of formats so you can pick one that Oracle understands.

Helen
(List Moderator)

>Best Regards
>Rama
>
>
>Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________