Reference Guide > TDV Support for SQL Functions > Date Functions > ISFINITE
 
ISFINITE
The isfinite() function is used to test for a finite date.
Syntax
ISFINITE(date/timestamp/interval)
Example
SELECT ISFINITE(TIMESTAMP '2020-06-20 12:59:59')
The above query returns TRUE.