TD_ISNAN Function | Teradata Vantage - TD_ISNAN - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_ISNAN evaluates a variable or expression to determine if the floating-point argument is a NaN (Not-a-Number) value. When a database table contains a NaN value, the data is undefined and unrepresentable in floating-point arithmetic. For example, division by 0, or the square root of a negative number would return a NaN result.