<< Click to Display Table of Contents >> Navigation:  SQL features > SQL92 functions

CAST(expression as datatype)
CURRENT_DATE: DATE
CURRENT_TIME
CURRENT_TIMESTAMP: TIMESTAMP
SUM(NUMBER): NUMBER
MAX()
MIN()
AVG(NUMBER)
COUNT
COALESCE(expression, expression)
FLOAT(STRING [,SEPARATORS]): NUMBER