The isValidTimeTz() function
Verifies whether a decoded h:m:s:micros+offset TimeTZ value is valid and within the Netezza Performance Server TimeTZ range.
Description
The function
has the following syntax:
inline bool isValidTimeTz(uint32 hour, uint32 minute, uint32 second,
uint32 mcrs, uint32 sqlOffset)
hour specifies the hour in the range of 0 to 23 inclusive.
minute specifies the minute in the range of 0 to 59 inclusive.
second specifies the second in the range of 0 to 59 inclusive.
mcrs specifies the microsecond in the range of 0 to 999999 inclusive.
sqlOffset specifies the time zone that is offset in minutes in the range of SQL_OFFSET_MIN to SQL_OFFSET_MAX inclusive.
Returns
False if isValidTime(hour, minute, second, mcrs) is false
isValidSqlOffset(sqlOffset) is false.
Otherwise, the function returns true.