Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Efficient date range search?

Re: Efficient date range search?

From: Dieter Nöth <dnoeth_at_gmx.de>
Date: Tue, 8 Oct 2002 08:44:25 +0200
Message-ID: <antupg$gs25v$3@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 - 01:44:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US