Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions
 

OpenEdge SQL Functions

This section provides detailed information on each SQL function. A description for each function provides the following information:
*A definition of the function
*The syntax of the function's proper usage
*A code sample that shows how the function works
*Any associated notes
* About OpenEdge SQL functions
* ABS
* ACOS
* ADD_MONTHS
* ASCII
* ASIN
* ATAN
* ATAN2
* AVG
* CASE
* CAST
* CDC_get_changed_columns
* CDC_is_column_changed
* CEILING
* CHAR
* CHR
* COALESCE
* CONCAT
* CONVERT (ODBC compatible)
* CONVERT (Progress extension)
* COS
* COUNT
* CURDATE
* CURTIME
* CURRVAL
* 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
* MAX
* MIN
* MINUTE
* MOD
* MONTH
* MONTHNAME
* MONTHS_BETWEEN
* NEXT_DAY
* NEXTVAL
* NOW
* NULLIF
* NVL
* PI
* POWER
* PREFIX
* PRO_ARR_DESCAPE function
* PRO_ARR_ESCAPE function
* PRO_ELEMENT function
* QUARTER
* RADIANS
* RAND
* REPEAT
* REPLACE
* RIGHT
* ROUND
* ROWID
* RPAD
* RTRIM
* SECOND
* SIGN
* SIN
* SQRT
* SUBSTR
* SUBSTRING (ODBC compatible)
* SUFFIX
* SUM
* SYSDATE
* SYSTIME
* SYSTIMESTAMP
* TAN
* TO_CHAR
* TO_DATE
* TO_NUMBER
* TO_TIME
* TO_TIMESTAMP
* TRANSLATE
* UCASE
* UPPER
* USER
* WEEK
* YEAR