Scalar Functions
This section listsProgress SQL-92 scalar functions. Table E–1 identifies the compatibility of the function as SQL-92 compatible, ODBC compatible, or a Progress extension.
Table E–1: Compatibility of SQL-92 Scalar Functions
Scalar Function
|
SQL-92
|
ODBC
|
Progress Extension
|
Notes
|
ABS
|
–
|
|
–
|
–
|
ACOS
|
–
|
|
–
|
–
|
ADD_MONTHS
|
–
|
–
|
|
–
|
ASCII
|
–
|
|
–
|
–
|
ASIN
|
–
|
|
–
|
–
|
ATAN
|
–
|
|
–
|
–
|
ATAN2
|
–
|
|
–
|
–
|
CAST
|
|
–
|
–
|
–
|
CEILING
|
–
|
|
–
|
–
|
CHAR
|
–
|
|
–
|
–
|
CHR
|
–
|
–
|
|
–
|
COALESCE
|
|
–
|
–
|
–
|
CONCAT
|
–
|
|
–
|
–
|
CONVERT
|
–
|
|
–
|
Requires ODBC escape clause – { fn }
|
CONVERT
|
–
|
–
|
|
Not compatible with ODBC CONVERT
|
COS
|
–
|
|
–
|
–
|
CURDATE
|
–
|
|
–
|
–
|
CURTIME
|
–
|
|
–
|
–
|
DATABASE
|
–
|
|
–
|
–
|
DAYNAME
|
–
|
|
–
|
–
|
DAYOFMONTH
|
–
|
|
–
|
–
|
DAYOFWEEK
|
–
|
|
–
|
–
|
DAYOFYEAR
|
–
|
|
–
|
–
|
DB_NAME
|
–
|
–
|
|
–
|
DECODE
|
–
|
–
|
|
–
|
DEGREES
|
–
|
|
–
|
–
|
EXP
|
–
|
|
–
|
–
|
FLOOR
|
–
|
|
–
|
–
|
GREATEST
|
–
|
–
|
|
–
|
HOUR
|
–
|
|
–
|
–
|
IFNULL
|
–
|
|
–
|
–
|
INITCAP
|
–
|
–
|
|
–
|
INSERT
|
–
|
|
–
|
–
|
INSTR
|
–
|
–
|
|
–
|
LAST_DAY
|
–
|
–
|
|
–
|
LCASE
|
–
|
|
–
|
–
|
LEAST
|
–
|
–
|
|
–
|
LEFT
|
–
|
|
–
|
–
|
LENGTH
|
–
|
|
–
|
–
|
LOCATE
|
–
|
|
–
|
–
|
LOG10
|
–
|
|
–
|
–
|
LOWER
|
|
–
|
–
|
–
|
LPAD
|
–
|
–
|
|
–
|
LTRIM
|
–
|
|
–
|
–
|
MINUTE
|
–
|
|
–
|
–
|
MOD
|
–
|
|
–
|
–
|
MONTH
|
–
|
|
–
|
–
|
MONTHNAME
|
–
|
|
–
|
–
|
MONTHS_BETWEEN
|
–
|
–
|
|
–
|
NEXT_DAY
|
–
|
–
|
|
–
|
NOW
|
–
|
|
–
|
–
|
NULLIF
|
|
–
|
–
|
–
|
NVL
|
–
|
|
|
–
|
PI
|
–
|
|
–
|
–
|
POWER
|
–
|
–
|
|
–
|
PREFIX
|
–
|
–
|
|
–
|
PRO_ARR_DESCAPE
|
–
|
–
|
|
–
|
PRO_ARR_ESCAPE
|
–
|
–
|
|
–
|
PRO_ELEMENT
|
–
|
–
|
|
–
|
QUARTER
|
–
|
|
–
|
–
|
RADIAN
|
–
|
|
–
|
–
|
RAND
|
–
|
|
–
|
–
|
REPEAT
|
–
|
|
–
|
–
|
REPLACE
|
–
|
|
–
|
–
|
RIGHT
|
–
|
|
–
|
–
|
ROUND
|
–
|
–
|
|
–
|
ROWID
|
–
|
–
|
|
–
|
RPAD
|
–
|
–
|
|
–
|
RTRIM
|
–
|
|
–
|
–
|
SECOND
|
–
|
|
–
|
–
|
SIGN
|
–
|
|
–
|
–
|
SIN
|
–
|
|
–
|
–
|
SQRT
|
–
|
|
–
|
–
|
SUBSTR
|
–
|
–
|
|
–
|
SUBSTRING
|
–
|
|
–
|
–
|
SUFFIX
|
–
|
–
|
|
–
|
SYSDATE
|
–
|
–
|
|
–
|
SYSTIME
|
–
|
–
|
|
–
|
SYSTIMESTAMP
|
–
|
–
|
|
–
|
TAN
|
–
|
|
–
|
–
|
TO_CHAR
|
–
|
–
|
|
–
|
TO_DATE
|
–
|
–
|
|
–
|
TO_NUMBER
|
–
|
–
|
|
–
|
TO_TIME
|
–
|
–
|
|
–
|
TO_TIMESTAMP
|
–
|
–
|
|
–
|
TRANSLATE
|
–
|
–
|
|
–
|
UCASE
|
–
|
|
–
|
–
|
UPPER
|
|
–
|
–
|
–
|
USER
|
|
|
|
–
|
WEEK
|
–
|
|
–
|
–
|
YEAR
|
–
|
|
–
|
–
|