DB2 LUW supports Date and Time arithmetic and the following Scalar and Column functions:
- AVG
- COUNT
- MAX
- MIN
- SUM
- CHAR
- DATE
- DAY
- DAYS
- DECIMAL
- FLOAT
- INTEGER
- HOUR
- LENGTH
- MICROSECOND
- MINUTE
- SECOND
- SUBSTR
- TIME
- TIMESTAMP
- YEAR
- CONCAT or the concatenation operator (||)
- VALUE
- DIGITS
- HEX
