ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-20
Functions
For more information, see the following documents:
Mathematical Functions
The NonStop ODBC Server supports the following CORE SQL mathematical functions:
•
EXP
•
MOD
•
PI
EXP
The EXP function has the following syntax:
The EXP (exponential) function returns the value of floating-expression
multiplied by the mathematical constant e (2.1718...).
MOD
The MOD function has the following syntax:
The MOD function returns the remainder (modulus) expressed by:
int-expression-1 – ( int-expression-1 / int-expression-2 ) * int-
expression-2
PI
The PI function has the following syntax:
The PI function returns the value 3.1415926535897936.
For Information About See
CORE SQL date functions Microsoft ODBC 2.1 Programmer’s Reference and SDK Guide
Datetime data Data Types
on page 3-8
EXP ( floating-expression )
MOD ( int-expression-1 , int-expression-2 )
PI ( )