Re: I must be missing the obvious

Hello, Joe,

[...]

> I get today 30-JUN-04. If there are 10 records in X including 3 from
> 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?

It's simple. Really your first query gets all the JUNE records. The second query gets record with datestamp less than '01-JUN-04 00:00:00' and records with datestamp equal to '01-JUN-2004 00:00:00' (not with 01-JUN-04 with some time portion). Again, '01-JUN-04 14:14:14' is greater than '01-JUN-04'.

[...]

Be careful with DD-MON-YY. Use DD-MON-RR (or DD-MON-YYYY) instead.

-- 
wbr,
Wit.