• SQL Functions Mapping to Other Databases
• Numeric Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATANH
  • ATAN2
  • CEILING
  • COS
  • COSH
  • COT
  • DEGREES
  • EXP
  • FLOOR
  • LN
  • LOG
  • LOG10
  • MOD
  • MULTIPLY_ALT
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIGN
  • SIN
  • SINH
  • SQRT
  • TAN
  • TANH
  • TRUNCATE
• String Functions
  • ASCII
  • CHARACTER_LENGTH
  • CHR
  • CONCAT
  • DIFFERENCE
  • INSERT
  • LENGTH
  • LCASE
  • LEFT
  • LOCATE
  • LTRIM
  • OCTET_LENGTH
  • POSITION
  • POSSTR
  • REPEAT
  • REPLACE
  • RIGHT
  • RTRIM
  • SOUNDEX
  • SPACE
  • STRIP
  • SUBSTR
  • SUBSTRING
  • TRANSLATE
  • TRIM
  • UCASE
• Date and Time Functions
  • DAY
  • DAYNAME
  • DAYOFWEEK
  • DAYOFWEEK_ISO
  • DAYOFYEAR
  • DAYS
  • HOUR
  • JULIAN_DAY
  • MICROSECOND
  • MIDNIGHT_SECONDS
  • MINUTE
  • MONTH
  • MONTHNAME
  • QUARTER
  • SECOND
  • TIMESTAMP_FORMAT
  • TIMESTAMP_ISO
  • TIMESTAMPDIFF
  • TO_CHAR
  • TO_DATE
  • VARCHAR_FORMAT
  • WEEK
  • WEEK_ISO
  • YEAR
• Analitic and Aggregate Functions
  • AVG
  • CORRELATION
  • COUNT
  • COUNT_BIG
  • COVARIANCE
  • GROUPING
  • MAX
  • MIN
  • REGR_AVGX
  • REGR_AVGY
  • REGR_COUNT
  • REGR_INTERCEPT or REGR_ICPT
  • REGR_R2
  • REGR_SLOPE
  • REGR_SXX
  • REGR_SXY
  • REGR_SYY
  • STDDEV
  • SUM
  • VARIANCE
• Conversion Functions
  • BIGINT
  • BLOB
  • CHAR
  • CLOB
  • DATE
  • DBCLOB
  • DECIMAL
  • DECRYPT_BIN
  • DECRYPT_CHAR
  • DIGITS
  • DOUBLE
  • ENCRYPT
  • FLOAT
  • GRAPHIC
  • HEX
  • REC2XML
  • INTEGER
  • LONG_VARCHAR
  • LONG_VARGRAPHIC
  • REAL
  • SMALLINT
  • TIME
  • TIMESTAMP
  • VARCHAR
  • VARGRAPHIC
• XML Functions
  • XMLAGG
  • XMLATTRIBUTES
  • XMLCOMMENT
  • XMLCONCAT
  • XMLDOCUMENT
  • XMLELEMENT
  • XMLFOREST
  • XMLNAMESPACES
  • XMLPARSE
  • XMLPI
  • XMLQUERY
  • XMLSERIALIZE
  • XMLTABLE
  • XMLTEXT
  • XMLVALIDATE
  • XMLXSROBJECTID
• Environment and System Functions
  • COALESCE
  • DEREF
  • EVENT_MON_STATE
  • GENERATE_UNIQUE
  • GETHINT
  • IDENTITY_VAL_LOCAL
  • NULLIF
  • RAISE_ERROR
  • TABLE_NAME
  • TABLE_SCHEMA
  • TYPE_ID
  • TYPE_NAME
  • TYPE_SCHEMA
  • VALUE
• Other Functions
  • DBPARTITIONNUM
  • HASHEDVALUE
  • SECLABEL
  • SECLABEL_BY_NAME
  • SECLABEL_TO_CHAR

SQLWays Product Page - Migration to IBM DB2 Free Evaluation