The decodeTimeTz() function

Converts a Netezza Performance Server-encoded TimeTz value to h:m:s:micros.

Description

The function has the following syntax:

inline void decodeTimeTz(int64 encodedTime, int32 encodedZone, uint8* 
hour,  uint8* minute, uint8* second, uint32* mcrs, int16* sqlOffset, 
bool* errorFlag = NULL)

encodedTime specifies a value that is encoded in Netezza Performance Server Time format.

encodedZone specifies a value that is encoded in Netezza Performance Server Time Offset format.

hour specifies the parameter in which to record the hour (0 - 23 inclusive).

minute specifies the parameter in which to record the minute (0 - 59 inclusive).

second specifies the parameter in which to record the second (0 - 59 inclusive).

mcrs specifies the parameter in which to record the microsecond (0 - 999,999 inclusive).

sqlOffset specifies the parameter in which to record the offset in minutes (SQL_OFFSET_MIN to SQL_OFFSET_MAX, inclusive).

errorFlag is an optional argument. If not NULL, it is set to true if isValidTimeTz(encodedTime, encodedZone) is false. Otherwise, it is set to false.

Throws

The function throws an opaque exception object if any(hour,minute,second,mcrs,sqloffset) is NULL or (errorFlag is NULL and isValidTimeTZ(encodedTime, encodedZone) is false).