Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How To Compare Date with Just the Day of Month
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
Received on Thu Jul 28 2005 - 08:30:20 CDT