Re: I must be missing the obvious
From: Wit Serdakovskij <wit_no_at_spam_dba.kiev.ua>
Date: 2 Jul 2004 10:45:25 GMT
Message-ID: <20040702104526.GA26790_at_tormoz.net>
Date: 2 Jul 2004 10:45:25 GMT
Message-ID: <20040702104526.GA26790_at_tormoz.net>
Hello, Joe,
[...]
> I get today 30-JUN-04. If there are 10 records in X including 3 from
It's simple. Really your first query gets all the JUNE records. The second
> today, why does
>
> 'select count(1) from X where datestamp < '01-JUL-04' return 10 but
>
> 'select count(1) from X where datestamp <= '30-JUN-04' returns 7?
[...]
Be careful with DD-MON-YY. Use DD-MON-RR (or DD-MON-YYYY) instead.
-- wbr, Wit.Received on Fri Jul 02 2004 - 12:45:25 CEST