to_char(date) gives the result 00-000-00

first row was inserted using the sql insert. remaining rows are inserted from the c++ engine

When i do to_char of the date y it give me 00-000-00

SQL> select to_char(y),y from x;

TO_CHAR(Y)	Y
---------------                 ---------
23-MAR-07	23-MAR-07
00-000-00	                01-JUN-01
00-000-00	                01-JUL-01
00-000-00	                01-OCT-01

But when i do to_char(to_date(y)) it give the correct dates

SQL> select to_char(to_date(y)),y from x;

TO_CHAR(TO_DATE Y

---------------                  ---------
23-MAR-07	23-MAR-07
01-JUN-01	                01-JUN-01
01-JUL-01	                01-JUL-01
01-OCT-01	                01-OCT-01

SQL> select dump(y) from x;

DUMP(Y)

Typ=12 Len=7: 120,107,3,23,16,52,56
Typ=12 Len=7: 120,101,6,1,0,0,0
Typ=12 Len=7: 120,101,7,1,0,0,0
Typ=12 Len=7: 120,101,10,1,0,0,0

Can anyone tell me what the problem is and how can it be resolved? Received on Mon Mar 26 2007 - 01:31:48 CDT