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

Try Now

Scalar Function Support for Informix

The table identifies the scalar functions that Hybrid Data Pipeline supports for Informix.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 178. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
CONCAT
ABS
CURDATE
DATABASE
LEFT
ACOS
CURTIME
IFNULL
LTRIM
ASIN
DAYOFMONTH
REPLACE
ATAN
DAYOFWEEK
RTRIM
ATAN2
MONTH
SUBSTRING
COS
NOW
COT
TIMESTAMPADD
EXP
TIMESTAMPDIFF
FLOOR
YEAR
LOG
LOG10
MOD
PI
POWER
ROUND
SIN
SQRT
TAN