search cancel

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 the 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/