Re: to_date function

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Wed, 19 Dec 2001 22:30:23 +0300
Message-ID: <9vqpvi$8lo$1@gavrilo.mtu.ru>

Just try

select * from tableA
where

created_date >= to_date('15/12/01', 'dd/mm/yy') and created_date < to_date('15/12/01', 'dd/mm/yy')+1;

It'll use indexes and will not pay attention to the time part of the your created_date column

"Katak" <kahtat_at_yahoo.com> wrote in message news:9vml6r$bhk$1_at_violet.singnet.com.sg...
> dear all
>
> I am having difficulty selecting records based on dates. Can anyone help?
>
> I tried using
> select * from tableA where created_date = to_date('15/12/01',
'dd/mm/yy');
>
> though i have records in the database. i do not get any results executing
> the above mentioned SQL code. anyone can lend a hand on this????? thanks
>
>
>
>
Received on Wed Dec 19 2001 - 13:30:23 CST