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

Try Now

Scalar Function Support for Sybase

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