Specify a function that returns a numeric value.

 

Syntax

 

<numeric value function> ::=

 

 

Usage

 

Numeric value functions can be used in SQL everywhere a numeric value is permitted.

 

 


 

Conformance

 

SQL:2003 standard

 

 

 

 

NexusDB extensions

-

-

-

-

 

-

-

-

-

-

-

-

-

-

-

Core SQL

Feature F052 "Intervals and datetime arithmetic"

Feature T441 "ABS and MOD functions"

Feature T621 "Enhanced numeric functions"

 

ATAN function

ATAN2 function

COS function

SIN function

ORD function

PI function

ROUND function

BROUND function

RAND function

LASTAUTOINC function