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

Try Now

Scalar Function Support for PostgeSQL

The table identifies the scalar functions that Hybrid Data Pipeline supports for PostgreSQL.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 186. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
IFNULL
CHAR
ACOS
CURRENT_DATE
USER
CONCAT
ASIN
CURRENT_TIME
INSERT
ATAN
CURRENT_TIMESTAMP
LCASE
ATAN2
CURTIME
LEFT
CEILING
DAYNAME
LENGTH
COS
DAYOFMONTH
LOCATE
COT
DAYOFWEEK
LOCATE_2
DEGREES
DAYOFYEAR
LTRIM
EXP
EXTRACT
REPEAT
FLOOR
HOUR
REPLACE
LOG
MINUTE
RIGHT
LOG10
MONTH
RTRIM
MOD
MONTHNAME
SPACE
PI
NOW
SUBSTRING
POWER
QUARTER
UCASE
RADIANS
SECOND
RAND
TIMESTAMPADD
ROUND
TIMESTAMPDIFF
SIGN
WEEK
SIN
YEAR
SQRT
TAN
TRUNCATE