DB2 graphic  QMF Version 8

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004