to_char(date) gives the result 00-000-00 More options
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?