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.