Functions

This chapter includes the following topics:
• •ADD_TO_DATE
• •ASCII
• •CEIL
• •CHOOSE
• •CHRCODE
• •COMPRESS
• •CONCAT
• •CONVERT_BASE
• •CRC32
• •DATE_COMPARE
• •DATE_DIFF
• •DEC_BASE64
• •DECODE
• •DECOMPRESS
• •FLOOR
• •GREATEST
• •IIF
• •IN
• •INDEXOF
• •INITCAP
• •INSTR
• •ISNULL
• •IS_DATE
• •IS_NUMBER
• •IS_SPACES
• •LEAST
• •LOWER
• •LPAD
• •LTRIM
• •MAKE_DATE_TIME
• •MAX (Numbers)
• •MD5
• •METAPHONE
• •MOD
• •POWER
• •REG_EXTRACT
• •REG_MATCH
• •REG_REPLACE
• •REPLACECHR
• •REPLACESTR
• •REVERSE
• •ROUND (Dates)
• •ROUND (Numbers)
• •RPAD
• •RTRIM
• •SET_DATE_PART
• •SIGN
• •SOUNDEX
• •SQRT
• •SUBSTR
• •SYSTIMESTAMP
• •TO_BIGINT
• •TO_CHAR (Dates)
• •TO_CHAR (Numbers)
• •TO_DATE
• •TO_DECIMAL
• •TO_FLOAT
• •TO_INTEGER
• •TRUNC (Dates)
• •TRUNC (Numbers)
• •UPPER