Is possible to modify the timezone of insertion of data at tstamp column of HP Vertica?

book

Article ID: 188273

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Hello, good afternoon?


I have the next question:


Is possible to modify the timezone of insertion of data at tstamp column of HP Vertica?


I know that by default teh timezone of insertion is UTC, but our customer wants to change it.


Thanks for your answer and support.


Regards.

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: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/DataTypes/Date-Time/TIMESTAMP.htm 

For configuring a timezone for not using UTC:

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/TZenvironmentVar.htm 

Additional Information

http://vertica-forums.com/viewtopic.php?t=493  

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SET/SETTIMEZONE.htm  

https://www.vertica.com/blog/understanding-time-zone/