The isValidTimeTzOffset() function

Verifies whether the offset part of a Netezza Performance Server-encoded TimeTZ value is valid and within range.

Description

The function has the following syntax:

inline bool isValidTimeTzOffset(int32 encodedZone)

The encodedZone value is encoded in Netezza Performance Server Time Offset format.

Returns

False if encodedZone > ENC_TIMETZ_OFFSET_MAX, or encodedZone < ENC_TIMETZ_OFFSET_MIN, or encodedZone%60 is not 0. Otherwise, the function returns true.