SQL & PL/SQL

Hello,

I have an issue with an old application. I tried to update date field with the value 01-JAN-99 but my application crash immediately.

In fact, I saw a strange date value in the table when I get the value with oracle function dump(): Typ=12 Len=7: 1,1,1,1,1,1,1 and after I get the value with to_char(t$demi, 'SYYYY/MM/DD HH24:MI:SS') => 00000/00/00 00:00:00.

See the example

select t$demi ,dump (t$demi) ,to_char(t$demi, 'SYYYY/MM/DD HH24:MI:SS') from T;

Result:

01-JAN-99   Typ=12 Len=7: 199,199,1,1,1,1,1  9999/01/01 00:00:00 01-JAN-99   Typ=12 Len=7: 1,1,1,1,1,1,1 00000/00/00 00:00:00

How to insert or update this kind of value in a existing table?

Thanks