Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How To Compare Date with Just the Day of Month
"Rhugga" <chuck.carson_at_gmail.com> wrote in message
news:1122557420.795340.5200_at_f14g2000cwb.googlegroups.com...
>
> I have the following date inserted into a DATE field: 07-26-2005
> 21:00:00
>
> I have some code where I want to see if this date is equal to
> 07-26-2005, regardless of the time of day.
>
> This is not working form me:
> WHERE bcv_start = to_date('$bcv_sdate[$j]', 'MM-DD-YYYY')
>
> (The value of $bcv_date is correct, I have check that several times)
> Thx,
> CC
>
use trunc(bcv_start) trunc on a date removes the fraction of a day and makes it midnight of that day which to_date('$bcv_sdate[$j]', 'MM-DD-YYYY') is. If it is slow then use a function based index on that field. Jim Received on Thu Jul 28 2005 - 08:37:52 CDT