There is a time component. 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)
Yes, you can truncate the created_date, but that will force a full table
scan just to get the date component as of midnight.
Jim
"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 Tue Dec 18 2001 - 09:36:31 CST
