Date and Time Usage Codes

Arithmetic functions cannot be specified for DATE, TIME, and TIMESTAMP values.

Usage codes allowed with DATE, TIME, and TIMESTAMP values:

ACROSS

GROUP

BREAKn (n=1,2,...,6)

LAST

BREAKnX (n=1,2,...6)

MAXIMUM

COUNT

MINIMUM

FIRST

OMIT

Usage codes not allowed with DATE, TIME, and TIMESTAMP values:

AVERAGE

STDEV

CPCT

SUM

CSUM

TCPCT

PCT

TPCT