A set of aggregate functions is provided to support time series data (optionally stored in Primary Time Index (PTI) tables). Additionally, some traditional functions support time series as well. To operate on time series data, both time series-specific functions and traditional functions are invoked in a GROUP BY TIME clause.