Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL FUNCITONS - Coggle Diagram
SQL FUNCITONS
Character Functions
Initcap(char)
Upper(char)
Lower(char)
replace(char,searchstring,[rep string])
Substr(char,m,n)
Translate(char, from, to)
Ltrim(char, set)
Rtrim(char, set)
Date Functions
add_months(d,n)
Last_day(n)
Months_between(d1,d2)
Next_day(d,day)
Round(d, [fmt])
Trunc(d, [fmt])
Greatest(d1, d2, d3...)
Numeric Functions
Trunc(m,n)
Round(m,n)
Cos(n)
Mod(m,n)
Cosh(n)
Power(m,n)
Conversion Functions
To_char(d, [fmt])
To_date(char, [fmt])