FUNCTIONS IN SQL
SQL functions that can be used to manipulate data. Such functions can be classified into the following three types:
Arithmetic functions. Character functions. Date functions.
Arithmetic functions:
ABS(n)n CEIL(n)
FLOOR(n)
MOD(m,n)
POWER(m,n)
Character functions:
CONCAT(string1, string2)
INITCAP(string)
LOWER(string)
UPPER(string)
SOUNDEX(string)
SUBSTR(string, M, N)
Date functions:
SYSDATE()
ADD_MONTH(D,N)
MONTH_BETWEEN(D1,D2)
TO_CHAR(D, ‘DAY’)
