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