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

.

Relevant Pages

  • Re: - Does Steph have a "real" job?
    ... > number and one time I believe somebody ask the contestants to compare ... Actually it was Greg who asked them to pick a number, ... Prev by Date: ...
    (alt.tv.survivor)
  • Reference multiple cells in if statement
    ... Source 1 is the standard to measure the other ... column BC needs to look at the data in E and compare the values of V and AP, ... it references only the 2 columns. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: that caravan tent thing
    ... Freecycle also. ... Doesn't really compare though, does it? ... Steve ... Prev by Date: ...
    (uk.rec.cars.maintenance)
  • Re: cdrom always shows a directory of an old cd
    ... Verify that /etc/vold.conf contains valid data. ... Compare it to /etc/vold.conf on a working system. ... Prev by Date: ...
    (comp.unix.solaris)
  • Re: white wins 1.26 more then black?
    ... you need to compare them to the expected results based on Elo. ... I recall reading somewhere that the advantage of white was something ... Prev by Date: ...
    (rec.games.chess.analysis)