match query interval to granularity for this test
timezone support in groupby query