Teradata Conditional Function | Notes |
COALESCE | |
DECODE | Version 15 and above. |
GREATEST | Version 15 and above. From Version 16, the DATE and TIMESTAMP data types are accepted as input and output. |
LEAST | Version 15 and above. From Version 16, the DATE and TIMESTAMP data types are accepted as input and output. |
NULLIF | |
NVL | |
NVL2 | Version 15 and above. |