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.
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
TIMESTAMPTZ. Applying the time zone occurs during extracting data based on the data loading process being executed.
timezone parameter is not set, ADD applies the default time zone, which is
For information about the name formats and time zone processing, see the Vertica online documentation.