Problem with to_char function
From: Mika N. <hunter_at_pcuf.fi>
Date: Fri, 27 Nov 1998 09:09:20 GMT
Message-ID: <365e6c12.67007637_at_news.carel.fi>
Hi!
Date: Fri, 27 Nov 1998 09:09:20 GMT
Message-ID: <365e6c12.67007637_at_news.carel.fi>
Hi!
[Quoted] [Quoted] I have a problem with to_char function in sql*plus (oracle 7.3.4).
I don't understand why my query selects all the rows...
select maakdi, chngdate
from maat
where to_char(chngdate, 'DD.MM.YYYY') >= '15.10.1998'
MA CHNGDATE
-- ----------
SK 16.02.1996 (why this row?) SK 15.10.1998 (this is OK) CZ 19.08.1997 (why this row?) CZ 19.08.1997 (why this row?)
-= Mika =- Received on Fri Nov 27 1998 - 10:09:20 CET