HiRDB Functions [Ispirer Migration Knowledge Base]

Ispirer Website Ispirer Capabilities - HiRDB Migration Free Trial

HiRDB Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- BITAND
- CEIL
- COS
- COSH
- EXP
- FLOOR
- LN
- LOG
- MOD
- NANVL
- POWER
- REMAINDER
- ROUND (number)
- SIGN
- SIN
- SINH
- SQRT
- TAN
- TANH
- TRUNC (number)
Date and Time Functions
- CURRENT_DATE
- CURRENT_TIMESTAMP
Analitic and Aggregate Functions
- AVG
- COUNT
Other Functions
- BFILENAME
- CARDINALITY
- COALESCE
- NULLIF
- NVL
- NVL2
- VALUE