updated the tests to reflect the time format and aggregation query changes