Entering content frame

Background documentation Processing SQL Statements Locate the document in its SAP Library structure

The MaxDB ODBC driver supports the complete ODBC SQL syntax.

Note

For detailed information about the ODBC function calls, see the Microsoft website (http://www.microsoft.com/data/ODBC) in the ODBC Software Development Kit (SDK) under ODBC Programmer‘s Reference, Chapter 8: SQL Statements, Escape Sequences in ODBC, Scalar Functions section.

 

Numeric functions

ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, TRUNCATE, PI, RADIANS, ROUND

String functions

CONCAT, LCASE, LEFT, LENGTH, LOCATE, LTRIM, REPLACE, RIGHT, RTRIM, SOUNDEX, SUBSTRING, UCASE,

System functions

DBNAME, IFNULL, USERNAME

Time and date functions

CURDATE, CURTIME, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, MONTHNAME, NOW, SECOND, WEEK, YEAR

Example

SELECT {fn MONTH(NOW())} FROM dual

 

The MaxDB ODBC driver has extensions to the usual SQL syntax in the following areas:

Database Procedures

Cursor Functions

 

Leaving content frame