Appendix E: Scalar Functions
ODBC specifies the following types of scalar functions, with detailed information about each of these function types provided in the corresponding sections of this appendix. The function descriptions include associated syntax.
This appendix contains the following topics.

ODBC does not mandate a data type for return values from scalar functions because the functions are often data sourceâ€“specific. Applications should use the CONVERT scalar function whenever possible to force data type conversion.
ODBC and SQL92 Scalar Functions
The tables in this appendix include functions that have been added in ODBC 3.0 to align with SQL92. Those functions added for a particular type of scalar function, as defined in ODBC, are indicated in each section.
ODBC and SQL92 classify their scalar functions differently. ODBC classifies scalar functions by argument type; SQL92 classifies them by return value. For example, the EXTRACT function is classified as a timedate function by ODBC, because the extractfield argument is a datetime keyword and the extractsource argument is a datetime or interval expression. SQL92, on the other hand, classifies EXTRACT as a numeric scalar function, because the return value is a numeric.
An application can determine which scalar functions a driver supports by calling SQLGetInfo. Information types are included both for ODBC and for SQL92 classifications of scalar functions. Because these classifications are different, the support for some scalar functions may be indicated in information types that do not correspond to ODBC and SQL92. For example, support for EXTRACT in ODBC is indicated by the SQL_TIMEDATE_FUNCTIONS information type; support for EXTRACT in SQL92, on the other hand, is indicated by the SQL_SQL92_NUMERIC_VALUE_FUNCTIONS information type.