Scalar functions¶
Scalar functions return one value per call.
Scalar functions
&(bitwiseAND)~(bitwiseNOT)|(bitwiseOR)<<(bitwise shift left)>>(bitwise shift right)- XOR (bitwise
XOR) - BETWEEN
- CASE
- COALESCE
- IN
- IS_ASCII
- IS NULL
- ISNULL
- FROM_UNIXTS, FROM_UNIXTSMS
- TO_HEX
- TO_UNIXTS, TO_UNIXTSMS
- CURDATE
- CURRENT_DATE
- CURRENT_TIMESTAMP
- DATEADD
- DATEDIFF
- DATEPART
- EOMONTH
- EXTRACT
- GETDATE
- SYSDATE
- TRUNC
- ABS
- ACOS
- Arithmetic operators
- ASIN
- ATAN
- ATN2
- CEILING / CEIL
- COS
- COT
- CRC64
- DEGREES
- EXP
- FLOOR
- LOG
- LOG10
- MOD,
% - PI
- POWER
- RADIANS
- ROUND
- SIN
- SQRT
- SQUARE
- TAN
- TRUNC
- CHAR_LENGTH
- CHARINDEX
||(Concatenate)- ISPREFIXOF
- LEFT
- LEN
- LIKE
- LOWER
- LTRIM
- OCTET_LENGTH
- PATINDEX
- REGEXP_COUNT
- REGEXP_INSTR
- REGEXP_SUBSTR
- REPLACE
- REVERSE
- RIGHT
- RLIKE
- RTRIM
- SUBSTRING
- TRIM
- UPPER