could say: 
`adu_date BETWEEN updateday and updateday + 1`