Hibernate sybase to Oracle timestamp issue

msubash26 · **Joined:** Mon Sep 06, 2010 5:49 am **Posts:** 3

Hi,

In our application we are retrieving data from sybase db table to Oracle db table, in which one column is date format.

In sybase we use it as datetime and in oracle timestamp.

It is storing values perfectly till the year of timestamp value is 2049. But if it goes beyond that it stores as 19XX, for example if the sybase table is having date as 2057-05-11 00:00:00.0, but after stored to oracle db, it has been converted to

to_char(date,'RRRR/dd/MM') - 1957/05/11.

Has anyone faced a simillar issue like this?

Please help me to resolve this,

Regards
Subash

shynate26 · **Posted:** Mon Sep 06, 2010 6:18 am

Which version of oracle you are using ?

msubash26 · **Joined:** Mon Sep 06, 2010 5:49 am **Posts:** 3

Oracle 10i..

shynate26 · **Posted:** Mon Sep 06, 2010 6:54 am

Hi Subhash,

Try select the date value with out transforming to_char. Then try with YYYY format. Get back with the results. Also publish your code snippet how the objects are handled to save the records.