Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Functions
SQL Functions Mapping to Other Databases
Numeric Functions
ABS
ACOS
ASIN
ATAN
ATAN2
COS
EXP
LOGN
LOG10
MOD
POW
ROOT
ROUND
SIN
SQRT
TAN
TRUNC
String Functions
CHAR_LENGTH
INITCAP
LENGTH
LOWER
LPAD
OCTET_LENGTH
REPLACE
RPAD
SUBSTR
TRIM
UPPER
Date and Time Functions
CURRENT
DATE
DAY
EXTEND
MDY
MONTH
TODAY
WEEKDAY
YEAR
Analitic and Aggregate Functions
AVG
CARDINALITY
MAX
MIN
RANGE
STDEV
SUM
VARIANCE
Conversion Functions
CAST
DECRYPT_CHAR
DECRYPT_BINARY
ENCRYPT_AES
ENCRYPT_TDES
GETHINT
HEX
TO_CHAR
TO_DATE
UNITS
Environment and System Functions
CURRENT_ROLE
DBINFO
DBSERVERNAME
DEFAULT_ROLE
IFX_ALLOW_NEWLINE
IFX_REPLACE_MODULE
USER
Other Functions
CASE
DECODE
FILETOBLOB
FILETOCLOB
LOCOPY
LOTOFILE
NVL