Describe the bug
Database is timezone unaware and some dates are local and others UTC creating confusion and wrong results.

To Reproduce
Run tests after daylight saving change of the time.

Expected behavior
All dates should be UTC.