skip to main content
Reference : ODBC API and Scalar Functions : Scalar Functions
  

Try DataDirect Drivers Now

Scalar Functions

You can use these scalar functions in SQL statements using the following syntax:
{fn scalar-function}
where scalar-function is one of the functions listed in the following tables. For example:
SELECT {fn UCASE(NAME)} FROM EMP
Table 36. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
CURSESSIONID
BIT_LENGTH
ACOS
CURTIME
CURRENT_USER
CHAR
ASIN
DAY
DATABASE
CHAR_LENGTH
ATAN
DATEDIFF
IDENTITY
CHARACTER_LENGTH
ATAN2
DAYNAME
USER
CONCAT
BITAND
DAYOFMONTH
DIFFERENCE
BITOR
DAYOFWEEK
HEXTORAW
BITXOR
DAYOFYEAR
INSERT
CEILING
EXTRACT
LCASE
COS
HOUR
LEFT
COT
MINUTE
LENGTH
DEGREES
MONTH
LOCATE
EXP
MONTHNAME
LOCATE2
FLOOR
NOW
LOWER
LOG
QUARTER
LTRIM
LOG10
SECOND
OCTET_LENGTH
MOD
SECONDS_SINCE_MIDNIGHT
RAWTOHEX
PI
TIMESTAMPADD
REPEAT
POWER
TIMESTAMPDIFF
REPLACE
RADIANS
TO_CHAR
RIGHT
RAND
WEEK
RTRIM
ROUND
YEAR
SOUNDEX
ROUNDMAGIC
SPACE
SIGN
SUBSTR
SIN
SUBSTRING
SQRT
UCASE
TAN
UPPER
TRUNCATE
* String Functions
* Numeric Functions
* Date and Time Functions
* System Functions