Examples: GROUP BY TIME with non-PTI Tables - Advanced SQL Engine - Teradata Database

Because GROUP BY TIME queries can be used with non-PTI tables, the USING TIMECODE clause provides a way to specify the timecode to use. If the USING TIMECODE clause is not specified when there are no PTI tables to infer a timecode from, an error is reported.

select avg(temperature)
from non_pti_tbl_seq
group by time(minutes(10))
using timecode(timecode);

select avg(temperature)
from non_pti_tbl_seq
group by time(minutes(10));

*** Failure 4359 Time Series: GROUP BY TIME clause may not be used without a TIMECODE specification.