> T> åÓÔØ ÔÁÂÌÉÞËÁ ÎÁËÌÁÄÎÙÈ.
> T> ÷ ÎÅÊ ÐÏÌÅ IN_DATE TIMESTAMP
> T> ðÏ ÎÉÍÕ ÅÓÔØ ÉÎÄÅËÓ.
> T> èÏÞÉÔÓÑ ×ÙÂÉÒÁÔØ ÄÁÎÎÙÅ ÚÁ ÕËÁÚÁÎÎÏÅ ÞÉÓÌÏ.
>
> T> âÙÌÏ-ÂÙ ÚÄÏÒÏ×Ï ÎÁÐÉÓÁÔØ × ÚÁÐÒÏÓÅ:
> T> where cast(IN_DATE as date) = :sel_date
> T> îÏ ÐÒÉ ÜÔÏÍ ÉÓÐÏÌØÚÕÅÔÓÑ NATURAL...
>
> 1) ÓÄÅÌÁÊ ÅÝÅ ÐÏÌÅ data É × ÔÒÉÇÇÅÒÁÈ before insert É before edit ÅÇÏ
> ÚÁÐÏÌÎÑÊ.
> îÁ ÜÔÏ ÐÏÌÅ ÓÄÅÌÁÊ ÉÎÄÅËÓ É ÐÏÎÅÍÕ ×ÙÂÏÒËÉ ÄÅÌÁÊ.
> 2) × yaffil ÅÓÔØ ÉÎÄÅËÓÙ ÐÏ ×ÙÒÁÖÅÎÉÀ. ôÏÖÅ ÄÌÑ Ô×ÏÅÇÏ ÓÌÕÞÁÑ ÄÏÌÖÎÙ
> ÐÏÄÏÊÔÉ.
Ñ ÂÙ ÉÈ ÒÁÚÄÅÌÉÌ ÎÁ DATE É TIME,
a ÅÓÌÉ ÏÞÅÎØ ÎÕÖÅÎ TIMESTAMP - ÍÏÖÎÏ ÅÇÏ ÓÄÅÌÁÔØ ×ÙÞÉÓÌÑÅÍÙÍ
--
ó Õ×ÁÖÅÎÉÅÍ
áÌÅËÓÅÊ áÂÒÁÍÏ×
X-Google-Language: RUSSIAN,KOI8R
Received: by 10.54.68.10 with SMTP id q10mr185542wra;
Mon, 22 May 2006 00:08:28 -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 v23si885585cwb.2006.05.22.00.08.26;
Mon, 22 May 2006 00:08:28 -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 1Fi4We-00013c-TR
for [email protected]; Mon, 22 May 2006 09:08:24 +0200
Received: from 217.173.2.17 ([217.173.2.17])
by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <[email protected]>; Mon, 22 May 2006 09:08:24 +0200
Received: from alex.abramov by 217.173.2.17 with local (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <[email protected]>; Mon, 22 May 2006 09:08:24 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: [email protected]
From: "áÌÅËÓÅÊ áÂÒÁÍÏ×" <[EMAIL PROTECTED]>
Subject: Re: ÷ÙÂÏÒËÁ ÐÏ ÄÁÔÅ
Date: Mon, 22 May 2006 11:12:26 +0400
Lines: 23
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
X-Complaints-To: [EMAIL PROTECTED]
X-Gmane-NNTP-Posting-Host: 217.173.2.17
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Sender: news <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
PiBUPiDQldGB0YLRjCDRgtCw0LHQu9C40YfQutCwINC90LDQutC70LDQtNC90YvRhS4KPiBUPiDQ
kiDQvdC10Lkg0L/QvtC70LUgSU5fREFURSBUSU1FU1RBTVAKPiBUPiDQn9C+INC90LjQvNGDINC1
0YHRgtGMINC40L3QtNC10LrRgS4KPiBUPiDQpdC+0YfQuNGC0YHRjyDQstGL0LHQuNGA0LDRgtGM
INC00LDQvdC90YvQtSDQt9CwINGD0LrQsNC30LDQvdC90L7QtSDRh9C40YHQu9C+Lgo+Cj4gVD4g
0JHRi9C70L4t0LHRiyDQt9C00L7RgNC+0LLQviDQvdCw0L/QuNGB0LDRgtGMINCyINC30LDQv9GA
0L7RgdC1Ogo+IFQ+IHdoZXJlIGNhc3QoSU5fREFURSBhcyBkYXRlKSA9IDpzZWxfZGF0ZQo+IFQ+
INCd0L4g0L/RgNC4INGN0YLQvtC8INC40YHQv9C+0LvRjNC30YPQtdGC0YHRjyBOQVRVUkFMLi4u
Cj4KPiAxKSDRgdC00LXQu9Cw0Lkg0LXRidC1INC/0L7Qu9C1IGRhdGEg0Lgg0LIg0YLRgNC40LPQ
s9C10YDQsNGFIGJlZm9yZSBpbnNlcnQg0LggYmVmb3JlIGVkaXQg0LXQs9C+IAo+INC30LDQv9C+
0LvQvdGP0LkuCj4g0J3QsCDRjdGC0L4g0L/QvtC70LUg0YHQtNC10LvQsNC5INC40L3QtNC10LrR
gSDQuCDQv9C+0L3QtdC80YMg0LLRi9Cx0L7RgNC60Lgg0LTQtdC70LDQuS4KPiAyKSDQsiB5YWZm
aWwg0LXRgdGC0Ywg0LjQvdC00LXQutGB0Ysg0L/QviDQstGL0YDQsNC20LXQvdC40Y4uINCi0L7Q
ttC1INC00LvRjyDRgtCy0L7QtdCz0L4g0YHQu9GD0YfQsNGPINC00L7Qu9C20L3RiyAKPiDQv9C+
0LTQvtC50YLQuC4KCtGPINCx0Ysg0LjRhSDRgNCw0LfQtNC10LvQuNC7INC90LAgREFURSDQuCBU
SU1FLAphINC10YHQu9C4INC+0YfQtdC90Ywg0L3Rg9C20LXQvSBUSU1FU1RBTVAgLSDQvNC+0LbQ
vdC+INC10LPQviDRgdC00LXQu9Cw0YLRjCDQstGL0YfQuNGB0LvRj9C10LzRi9C8CgotLSAK0KEg
0YPQstCw0LbQtdC90LjQtdC8CtCQ0LvQtdC60YHQtdC5INCQ0LHRgNCw0LzQvtCyIAoKCgoKLS1+
LS1+LS0tLS0tLS0tfi0tfi0tLS1+LS0tLS0tLS0tLS0tfi0tLS0tLS1+LS1+LS0tLX4KLX4tLS0t
LS0tLS0tfi0tLS1+LS0tLX4tLS0tfi0tLS0tLX4tLS0tfi0tLS0tLX4tLX4tLS0KCg==
