Time Zones in Automated Data Distribution

When you are scheduling a data loading process for Automated Data Distribution (see Schedule a Data Load), you can optionally add the timezone parameter to the scheduled process.

The timezone parameter identifies the time zone that ADD will apply to the data records in the Output Stage that have a data type of either TIMETZ or TIMESTAMPTZ. Applying the time zone occurs during extracting data based on the data loading process being executed.

If the timezone parameter is not set, ADD applies the default time zone, which is Europe/Prague.

For information about the name formats and time zone processing, see the Vertica online documentation.