skip to main content
Querying data stores with SQL : Supported scalar functions : Scalar Function Support for Progress OpenEdge
  

Try Now

Scalar Function Support for Progress OpenEdge

Applications connecting through JDBC or ODBC to Progress OpenEdge® can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 187. Scalar Functions for Progress OpenEdge
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURRENT DATE
DATABASE
BIT_LENGTH
ACOS
CURRENT_TIME
IFNULL
CHAR
ASIN
CURRENT_TIMESTAMP
ROWID
CHAR_LENGTH
ATAN
CURDATE
USER
CHARACTER_LENGTH
ATAN2
CURTIME
CONCAT
CEILING
DAYNAME
DIFFERENCE
COS
DAYOFMONTH
INSERT
COT
DAYOFWEEK
LCASE
DEGREES
DAYOFYEAR
LEFT
EXP
HOUR
LENGTH
FLOOR
MINUTE
LOCATE
LOG
MONTH
LTRIM
LOG10
MONTHNAME
OCTET_LENGTH
MOD
NOW
POSITION
PI
QUARTER
REPEAT
POWER
SECOND
REPLACE
RADIANS
TIMESTAMPADD
RIGHT
RAND
TIMESTAMPDIFF
RTRIM
ROUND
WEEK
SPACE
SIGN
YEAR
SUBSTRING
SIN
UCASE
SQRT
TAN
TRUNCATE