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

Try Now

Scalar Function Support for Progress Rollbase

The table identifies the scalar functions that Hybrid Data Pipeline supports for Progress Rollbase.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 188. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
CURSESSIONID
BIT_LENGTH
ACOS
CURTIME
DATABASE
CHAR
ASIN
DATEDIFF
IDENTITY
CHAR_LENGTH
ATAN
DAY
USER
CHARACTER_LENGTH
ATAN2
DAYNAME
IFNULL
CONCAT
CEILING
DAYOFMONTH
DIFFERENCE
BITAND
DAYOFWEEK
HEXTORAW
BITOR
DAYOFYEAR
INSERT
BITXOR
EXTRACT
LCASE
COS
HOUR
LEFT
COT
MINUTE
LENGTH
DEGREES
MONTH
LOCATE
EXP
MONTHNAME
LOCATE_2
FLOOR
NOW
LOWER
LOG
SECOND
LTRIM
LOG10
TO_CHAR
OCTET_LENGTH
MOD
WEEK
RAWTOHEX
PI
YEAR
REPEAT
POWER
REPLACE
RADIANS
RIGHT
RAND
RTRIM
ROUND
SOUNDEX
SIGN
SPACE
SIN
SUBSTR
SQRT
SUBSTRING
TAN
UCASE
TRUNCATE
UPPER
ROUNDMAGIC