Time with time zone (timetz) data type

The time with time zone (timetz) data type is an exact data type that is stored in 12 bytes.

Internally, the Netezza Performance Server system stores the data type as time and an offset. The stored offset has the same 1μS resolution as the time, even though the input is restricted to a 1-minute resolution.

Syntax

<time> ( '+' | '-' ) <digit> [ <digit> [ ':' <digit> [ <digit> ] ] ]

The input format of the time with time zone value is identical to that of a simple time value followed by a trailing signed offset from Coordinated Universal Time (UTC, formerly Greenwich Mean Time or GMT). The time section must conform to the values of the -timeStyle and -timeDelim options that are in effect during the nzload command job.

You must specify a signed timezone hour, whereas the timezone minute is optional. If you use the minute, separate it with a colon (the default -timeDelim option character).

Errors

For the time portion of the data type, the errors for the time data type apply. The time zone offset is restricted to -13:00 to +12:59.

Using a named time zone, such as EST, produces an error.