ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-18
Functions
functions, then describes, by the following function types, how to use the supported
functions:
•
Date functions
•
Mathematical functions
•
String functions
•
System functions
Summary of Transact-SQL Functions
Table 4-7 summarizes the supported Transact-SQL functions. Descriptions of each
function follow the table.
For a complete list of the Transact-SQL functions, see Appendix B, Summary of
Support for SQL Server Features.
Table 4-7. Supported Transact-SQL Functions
Function Type Function Comments
Date DATEADD See Date Functions
on page 4-19 for descriptions of
all date functions.
DATEDIFF
DATEPART
GETDATE
Mathematical EXP Fully supported
PI Fully supported
POWER Fully supported
String UPPER Fully supported
System DB_NAME All parameters are ignored; the function always
returns the current database name.
SUSER_NAME All parameters are ignored; the function always
returns the current username.
USER_ID All parameters are ignored; the function always
returns an integer used internally to identify a user.
USER_NAME All parameters are ignored; the function always
returns the current username.
Conversion CONVERT The style parameter is ignored, and there are
restrictions when converting to or from a datetime
value. See Conversion Function
on page 4-24.