Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How To Compare Date with Just the Day of Month

Re: How To Compare Date with Just the Day of Month

From: Wally <wallyraju_at_gmail.com>
Date: 28 Jul 2005 06:37:46 -0700
Message-ID: <1122557866.623932.35580@z14g2000cwz.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US