Skip to main content

timezone

  • March 15, 2015
  • 4 replies
  • 17 views

David_Chen
Forum|alt.badge.img+1

 

 

How do we update the time zone database?

 

For example,

 

david=> select now() at time zone 'Africa/Johannesburg';
          timezone          
----------------------------
 2015-03-15 14:38:57.038857
(1 row)

 

Works

 

However, the following fails:


david=> select now() at time zone 'Africa/Juba';
ERROR 5038:  Timezone "Africa/Juba" not recognized
david=>

 

 

 

Yet, "Africa/Juba" is listed as a valid time zone. 

 

http://en.wikipedia.org/wiki/List_of_tz_database_time_zones

 

 

4 replies

Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • March 16, 2015

Hi 

 

This timezone " Africa/Juba" is not listed in the Vertica document for supported timezone for Africa which is the reason behind getting this error.

 

I will suggest you to kindly go through below Vertica documented link to check the same:

 

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/InstallationGuide/AppendixTimeZones/Africa.htm%3FTocPath%3DInstallation%20Guide%7CAppendix%3A%20Time%20Zones%7C_____2

 

 

Regards

Rahul Choudhary

 


David_Chen
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 16, 2015

 

Is there a way for us to add support for "Africa/Juba" (and all other official timezones that are supposed to be supported), either via a config file or a patch from Vertica?

 

 


Rahul_Choudhary
Forum|alt.badge.img
  • Participating Frequently
  • March 16, 2015

Hi

 

I would suggest you to raise a support case if you are an esteemed customer & have support license with vertica then only we can further see if there is a possibility to raise an enhancement request with our engineering expert as you have requested.

 

So for now you can use the timezone as have been mentioned in the vertica documentation.

 

Regards

Rahul Choudhary


DerrickR
Forum|alt.badge.img
  • Participating Frequently
  • March 16, 2015

David:

 

We have intentions* of switching over to using the local systems TZ data rather than using TZ data internal to Vertica. Vertica currently only supports timezones listed in the documentation previously linked.

 

Sorry for the trouble. Please do follow up with Technical Support if you have a support contract.

 

- Derrick

 

* Please note that intentions are not commitments. My statement is mine alone; not an official HP Vertica statement.