Hi, guys

Can anybody explain me that result:

Code:
select '>'||to_char(t$invd,'YYYY')||'<', to_char(t$invd,'DD.MM.YYYY'),t$invd,sysdate from baandb.TTDSLS045550 where rownum < 2 and t$orno=41;

'>'||T TO_CHAR(T$ T$INVD    SYSDATE
------ ---------- --------- ---------
>0000< 00.00.0000 01-JAN-99 03-MAY-02
It seems to me function to_char does not return correct result or may be I do not understand somethink?
field t$invd has DATE format.
Oracle 8.1.6, SUN, Solaris.

The same query works fine on Oracle 7.3 (WinNt)

Thanks.


[Edited by kgb on 05-03-2002 at 07:22 AM]