The decodeTime() function

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

Description

The function has the following syntax:

inline void decodeTime(int64 encodedTime, uint8* hour, uint8* minute, 
uint8* second, uint32* mcrs, bool* errorFlag = NULL))

encodedTime specifies a value that is encoded in Netezza Performance Server Time 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).

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

Throws

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