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

Try Now

Scalar Function Support for Microsoft SQL Server

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