ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-22
Functions
Variable Expressions in Date Functions
The NonStop ODBC Server does not support variable expressions in date functions.
For example, the following statement is not allowed:
select dateadd ( month, @v1 + @v2, getdate() )
Simple variables, however, are allowed in date functions.
For more information, see the following documents:
Mathematical Functions
The NonStop ODBC Server supports the following Transact-SQL mathematical
functions:
•
EXP
•
PI
•
POWER
All of these functions are fully supported.
EXP
The EXP function has the following syntax:
EXP returns the exponential value of the specified argument.
PI
The PI function has the following syntax:
PI returns the constant value 3.1415926535897936.
POWER
The POWER function has the following syntax:
For Information On See
Transact-SQL date functions Microsoft SQL Server Transact-SQL Reference
Datetime data Data Types
on page 4-12.
EXP ( floating-expression )
PI ( )
POWER ( numeric-expression-1,numeric-expression-2 )