Re: Problem with to_char function
From: Darren John Capper <darren.capper_at_preci-spark.uk.com>
Date: Fri, 27 Nov 1998 15:31:31 +0000
Message-ID: <365EC5D3.C26DB9B2_at_preci-spark.uk.com>
Date: Fri, 27 Nov 1998 15:31:31 +0000
Message-ID: <365EC5D3.C26DB9B2_at_preci-spark.uk.com>
Try
select a.maakdi, a.chngdate
from maat a
where to_date(to_char(a.chngdate, 'DD.MM.YYYY'),'DD.MM.YYYY') >=
to_date('15.10.1998','DD.MM.YYYY');
Mika N. wrote:
> Hi!
>
> 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 - 16:31:31 CET