SQL to_date problem

From: MGperY <mgyuri_at_freemail.c3.hu>
Date: Thu, 22 Oct 1998 19:09:30 +0200
Message-ID: <70np0i$3kq@helka.iif.hu>

Hi there !

I have 2 querys:
select distinct 0 from boltok, bma

                    where ba_bjkod=bj_kod

 and ba_erkezes=to_date('1998/09','YYYY/MM');

---

 select distinct 0 from boltok, bma

                    where ba_bjkod=bj_kod

 and to_char(ba_erkezes,'YYYY/MM')='1998/09';

the 1st give me no rows, the 2nd give me 1 row, wich is the correct answer. I think these two must have the same result, but somethings is be wrong with the format mask.
Can you help me ?

(I don't want to use the 2nd, because it does not use my index, and the bma has 80000 rows...)

thanx

M. Received on Thu Oct 22 1998 - 12:09:30 CDT