HOW to use TO_CHAR() function?
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]
Irrational date behaviour- Thread Open?
Hi
There have been problems with date behaviour
See thread 16743 to find more about date
behaviour.
Still it can't be explained why it returns 00.00.0000 even if the date be 01-JAN-9999.
Is this thread still open?
Cheers
Nandu