I think that to take care of the timezone issue, we could just add the difference to the query itself.