Options
timezone
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
0
Comments
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
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?
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
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.