Menu
Simba Technologies
Simba Technologies

SimbaEngine X SDK 10.1.3
Developing Drivers for Data Stores Without SQL

SimbaEngine X SDK Documentation > Specifications > Supported ODBC/SQL Functions

Supported ODBC/SQL Functions

This section lists the ODBC-defined scalar functions that are supported by the SQL Engine.

Explicit Covert functions

  • CONVERT
  • CAST

String Functions

  • ASCII
  • CHAR
  • CONCAT
  • INSERT
  • LCASE
  • LEFT
  • LENGTH
  • LOCATE
  • LTRIM
  • REPEAT
  • REPLACE
  • RIGHT
  • RTRIM
  • SOUNDEX
  • SPACE
  • SUBSTRING
  • UCASE

System Functions

  • DATABASE
  • IFNULL
  • USER

Numeric Functions

  • ABS

  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • CEILING
  • COS
  • COT
  • DEGREES
  • EXP
  • FLOOR
  • LOG
  • LOG10
  • MOD
  • PI
  • POWER
  • RADIANS
  • RAND
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • TAN
  • TRUNCATE

Aggregate Functions

  • AVG
  • COUNT
  • MAX
  • MIN
  • STDDEV
  • STDDEV_POP
  • SUM
  • VAR
  • VAR_POP

Time, Date, and Interval Functions

  • CURDATE
  • CURTIME
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIME (time precision)
  • CURRENT_TIMESTAMP
  • CURRENT_TIMESTAMP (time precision)
  • DAYNAME
  • DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • HOUR
  • MINUTE
  • MONTH
  • MONTHNAME
  • NOW
  • QUARTER
  • SECOND
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • WEEK
  • YEAR