Isn't ```BETWEEN``` inclusive? That'd be slightly different if so, equivalent to:

```date_processed >= updateday AND date_processed <= updateday + 1```