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
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
>
>
You are using the wrong end of the shovel to dig a hole.
Is "$bcv_sdate[$j]" a string or a date datatype?
This appears to be SQL embedded in PERL code.
WHERE TRUNC(BCV_START) = $bcv_sdate[$j]? Received on Thu Jul 28 2005 - 08:36:27 CDT