TD_ISNAN Function | Teradata Vantage - TD_ISNAN - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
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.