The isValidInterval() function

Verifies whether a Netezza Performance Server-encoded Interval value is valid and within range.

Description

The function has the following syntax:
inline bool isValidInterval(int32 intervalMonth, int64 intervalTime)

intervalMonth specifies the Month part of an Interval encoded in Netezza Performance Server format.

intervalTime specifies the Time part of an Interval encoded in Netezza Performance Server format.

Returns

False if intervalMonth < ENC_INTERVAL_MONTH_MIN or intervalMonth > ENC_INTERVAL_MONTH_MAX. Otherwise, the function returns true.