Built-In Scalar functions

Built-in scalar functions return one value per call.

Built-in scalar functions

• & (bitwise AND)
• ~ (bitwise NOT)
• | (bitwise OR)
• << (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_REPLACE
• REGEXP_SUBSTR
• REPEAT
• REPLACE
• REVERSE
• RIGHT
• RLIKE
• RTRIM
• SUBSTRING
• TRIM
• UPPER