$monArray[$i] = sprintf("%02d", $monArray[$i] + 1); #### SELECT foo, bar, baz FROM empfile WHERE anniversary BETWEEN TO_DATE( ?, 'MM/DD' ) AND TO_DATE( ?, 'MM/DD' )