Re: Efficient date range search?
From: (wrong string) öth <dnoeth_at_gmx.de>
Date: Tue, 8 Oct 2002 08:44:25 +0200
Message-ID: <antupg$gs25v$3_at_ID-28204.news.dfncis.de>
Date: Tue, 8 Oct 2002 08:44:25 +0200
Message-ID: <antupg$gs25v$3_at_ID-28204.news.dfncis.de>
Jonathan Leffler wrote:
> Then the criterion for 'alive at time 2001-07-04 19:30:00' is:
>
> WHERE born <= TIMESTAMP '2001-07-04 19:30:00'
> AND died >= TIMESTAMP '2001-07-04 19:30:00'
why not
TIMESTAMP '2001-07-04 19:30:00' BETWEEN born AND died
Dieter Received on Tue Oct 08 2002 - 08:44:25 CEST