Выборка по дате

Sat, 20 May 2006 10:49:40 -0700 


Есть табличка накладных.
В ней поле IN_DATE TIMESTAMP
По ниму есть индекс.
Хочится выбирать данные за указанное число.

Было-бы здорово написать в запросе:
where cast(IN_DATE as date) = :sel_date
Но при этом используется NATURAL...

Приходиться писать
where IN_DATE between :dstart and :dend
и вкорячивать логику в приложение.

Собственно вопрос:
Можно ли как-нибудь использавать индекс по полю TIMESTAMP в выборках по дате без логики на клиенте? 

Сейчас сервер 1.5.3
Что в 2.х по этому поводу?

X-Google-Language: RUSSIAN,KOI8R
Received: by 10.54.68.17 with SMTP id q17mr144135wra;
       Sat, 20 May 2006 04:39:55 -0700 (PDT)
Return-Path: <[EMAIL PROTECTED]>
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
       by mx.googlegroups.com with ESMTP id v11si351341cwb.2006.05.20.04.39.53;
       Sat, 20 May 2006 04:39:55 -0700 (PDT)
Received-SPF: pass (googlegroups.com: domain of [EMAIL PROTECTED] designates 
80.91.229.2 as permitted sender)
Received: from list by ciao.gmane.org with local (Exim 4.43)
        id 1FhPo6-00048k-NN
        for [email protected]; Sat, 20 May 2006 13:39:42 +0200
Received: from gt-fm.academ.org ([81.222.113.152])
       by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
       id 1AlnuQ-0007hv-00
       for <[email protected]>; Sat, 20 May 2006 13:39:42 +0200
Received: from tonal by gt-fm.academ.org with local (Gmexim 0.1 (Debian))
       id 1AlnuQ-0007hv-00
       for <[email protected]>; Sat, 20 May 2006 13:39:42 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: [email protected]
From: Tonal <[EMAIL PROTECTED]>
Subject: =?KOI8-R?Q?=F7=D9=C2=CF=D2=CB=C1_=D0=CF_=C4=C1=D4=C5?=
Date: Sat, 20 May 2006 18:39:25 +0700
Lines: 19
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
X-Complaints-To: [EMAIL PROTECTED]
X-Gmane-NNTP-Posting-Host: gt-fm.academ.org
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
Sender: news <[EMAIL PROTECTED]>

0JXRgdGC0Ywg0YLQsNCx0LvQuNGH0LrQsCDQvdCw0LrQu9Cw0LTQvdGL0YUuCtCSINC90LXQuSDQ
v9C+0LvQtSBJTl9EQVRFIFRJTUVTVEFNUArQn9C+INC90LjQvNGDINC10YHRgtGMINC40L3QtNC1
0LrRgS4K0KXQvtGH0LjRgtGB0Y8g0LLRi9Cx0LjRgNCw0YLRjCDQtNCw0L3QvdGL0LUg0LfQsCDR
g9C60LDQt9Cw0L3QvdC+0LUg0YfQuNGB0LvQvi4KCtCR0YvQu9C+LdCx0Ysg0LfQtNC+0YDQvtCy
0L4g0L3QsNC/0LjRgdCw0YLRjCDQsiDQt9Cw0L/RgNC+0YHQtToKd2hlcmUgY2FzdChJTl9EQVRF
IGFzIGRhdGUpID0gOnNlbF9kYXRlCtCd0L4g0L/RgNC4INGN0YLQvtC8INC40YHQv9C+0LvRjNC3
0YPQtdGC0YHRjyBOQVRVUkFMLi4uCgrQn9GA0LjRhdC+0LTQuNGC0YzRgdGPINC/0LjRgdCw0YLR
jAp3aGVyZSBJTl9EQVRFIGJldHdlZW4gOmRzdGFydCBhbmQgOmRlbmQK0Lgg0LLQutC+0YDRj9GH
0LjQstCw0YLRjCDQu9C+0LPQuNC60YMg0LIg0L/RgNC40LvQvtC20LXQvdC40LUuCgrQodC+0LHR
gdGC0LLQtdC90L3QviDQstC+0L/RgNC+0YE6CtCc0L7QttC90L4g0LvQuCDQutCw0Lot0L3QuNCx
0YPQtNGMINC40YHQv9C+0LvRjNC30LDQstCw0YLRjCDQuNC90LTQtdC60YEg0L/QviDQv9C+0LvR
jiBUSU1FU1RBTVAg0LIg0LLRi9Cx0L7RgNC60LDRhSDQv9C+IArQtNCw0YLQtSDQsdC10Lcg0LvQ
vtCz0LjQutC4INC90LAg0LrQu9C40LXQvdGC0LU/CgrQodC10LnRh9Cw0YEg0YHQtdGA0LLQtdGA
IDEuNS4zCtCn0YLQviDQsiAyLtGFINC/0L4g0Y3RgtC+0LzRgyDQv9C+0LLQvtC00YM/CgoKLS1+
LS1+LS0tLS0tLS0tfi0tfi0tLS1+LS0tLS0tLS0tLS0tfi0tLS0tLS1+LS1+LS0tLX4KLX4tLS0t
LS0tLS0tfi0tLS1+LS0tLX4tLS0tfi0tLS0tLX4tLS0tfi0tLS0tLX4tLX4tLS0KCg==

Ответить