Fixed #17260 -- Added time zone aware aggregation and lookups.