Actually it is supposed to give correct results
As a bonus it follows standard DB practices rather than falling into the 9/9/99
trap which everyone was so worried about a couple of years ago.
On Mon, 7 Oct 2002, Jean-Luc Lachance wrote:
> And that is supposed to be more efficient then
> select * from pets where died > {whatever date};
>
> C'mon...
>
>
> "Nigel J. Andrews" wrote:
> >
> > SELECT *
> > FROM pets
> > WHERE
> > born <= '2001-07-04 07:01:00+00'
> > AND
> > (
> > died > '2001-07-04 07:01:00+00'
> > OR
> > died is NULL
> > )