Oracle Database Discussions

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 informix date to oracle equivalent

625129May 27 2008 — edited May 29 2008

hi all
I am new to the forum, I did some research before posting the thread. I am excited to see all the response, Good work.

I am working on migration of Informix dynamic server 9.0X to oracle 10g, i used OMWB tool which converts the code part with here n there manual intervention needed.
At one such instance i had this......

let ln_Numdays = (extend(pd_InDate, year to day) - datetime(1970-01-01) year to day)::interval day(9) to day::varchar(30)::integer;

i want this in oracle equivalent.

Thanks in advance, any kind of help appriciated

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2008

Added on May 27 2008

#database-and-application-migrations

3 comments

2,163 views