The encodeTimeTZ() function

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

Description

The function has the following syntax:

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

hour specifies the hour in the range 0 - 23 inclusive.

minute specifies the minute in the range 0 - 59 inclusive.

second specifies the second in the range 0 - 59 inclusive.

mcrs specifies the microsecond in the range 0 - 999,999 inclusive.

sqlOffset specifies the time zone that is offset in minutes in the range of SQL_OFFSET_MIN to SQL_OFFSET_MAX inclusive.

encodedTime specifies the parameter in which to record the Time that is encoded in Netezza Performance Server format.

encodedZone specifies the parameter in which to record the Time Offset in Netezza Performance Server format.

errorFlag is an optional argument. If not NULL, it is set to true if isValidTimeTz(hour, minute, second, mcrs) is false. Otherwise, it is set to false.

Throws

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