For each DBMS, only functions with a green check mark can be used.
Adelia Function |
DB2 |
SQL Server |
Oracle |
ABSOLUTE_VALUE |
|
|
|
ARC_COSINE |
|
|
|
ARC_SINE |
|
|
|
ARC_TANGENT |
|
|
|
CONCAT |
|
|
|
COSINE |
|
|
|
CURRENT_DATE |
|
|
|
CURRENT_TIME |
|
|
|
CURRENT_TMSTP |
|
|
|
DAY_OF_MONTH |
|
|
|
DAY_OF_WEEK |
|
|
|
DAY_OF_YEAR |
|
|
|
EXPONENTIAL |
|
|
|
FLOOR |
|
|
|
HOUR |
|
|
|
IF_NULL |
|
|
|
IS_NULL_IND |
|
|
|
LEFT |
|
|
|
LOGARITHM_10 |
|
|
|
LOGARITHM_N |
|
|
|
LOWERCASE |
|
|
|
LTRIM |
|
|
|
MINUTE |
|
|
|
MODULO |
|
|
|
MONTH |
|
|
|
PI |
|
|
|
POWER_OF |
|
|
|
QUARTER |
|
|
|
RTRIM |
|
|
|
SECOND |
|
|
|
SINE |
|
|
|
SQUARE_ROOT |
|
|
|
STRING_LENGTH |
|
|
|
SUBSTRING |
|
|
|
TANGENT |
|
|
|
UPPER_CASE |
|
|
|
WEEK |
|
|
|
YEAR |
|
|
|
