Re: I must be missing the obvious

[...]

> > > 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.

[...]

> Don't use an implicit conversion of a string to a date! Use to_date()
> instead. You have bug in your code just waiting to bite you.

Agreed. That's just a notation from replied message...

-- 
wbr,
Wit.