Modify the timezone of insertion of data at tstamp column of HP Vertica
Article ID: 188273
Updated On:
Products
CA Infrastructure Management
CA Performance Management - Usage and Administration
DX NetOps
Issue/Introduction
Is possible to modify the timezone of insertion of data at tstamp column of HP Vertica?
By default the timezone of insertion is UTC, but your customer wants to change it.
Environment
Release : 3.6
Component : IM Reporting / Admin / Configuration
Resolution
"TIMESTAMP WITH TIME ZONE: Specifies to convert input-string to UTC, using the UTC offset for the specified time zone. If the input string omits a time zone, Vertica uses the UTC offset of the time zone that is configured for your system (***)."
Source: TIMESTAMP/TIMESTAMPTZ
For configuring a timezone for not using UTC: TZ Environment Variable
Additional Information
Feedback
Yes
No
Powered by
