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

Try Now

Scalar Function Support for MySQL

The table identifies the scalar functions that Hybrid Data Pipeline supports for MySQL.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 181. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
DATABASE
CHAR
ACOS
CURRENT_DATE
IFNULL
CONCAT
ASIN
CURRENT_TIME
USER
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
SOUNDEX
PI
NOW
SPACE
POWER
QUARTER
SUBSTRING
RADIANS
SECOND
UCASE
RAND
TIMESTAMPADD
ROUND
TIMESTAMPDIFF
SIGN
WEEK
SIN
YEAR
SQRT
TAN
TRUNCATE