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
sorry, my bad. ignore my previos post.
try
WHERE to_char(bcv_start,'MM-DD-YYYY') = $bcv_sdate[$j]
that way you compare only the date part of the bcv_start field. By make sure that the value of the vairable = $bcv_sdate[$j] is in the same format MM-DD-YYYY.
Wally Received on Thu Jul 28 2005 - 08:37:46 CDT