Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-12 Thread Steve Crawford
On Tue, Sep 12, 2017 at 11:07 AM, Zbigniew Szmigiero wrote: > > Hi Steve, > > You do not test syntax provided in my examples: > > 1. ALTER DATABASE name SET TIME ZONE to ‚timezone’ > > You used TIMEZONE instead of TIME ZONE - please check > > Your examples do not match the

Re: [DOCS] LOCAL and TIME ZONE in SET

2017-09-11 Thread Steve Crawford
On Fri, Sep 8, 2017 at 1:05 PM, wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.5/static/sql-alterdatabase.html > Description: > > The ALTER DATABASE name TIME ZONE ... is rejected > > THE ALTER

Re: [DOCS] Reg Date/Time function

2017-08-01 Thread Steve Crawford
Per the docs, justify_days is to "Adjust interval so 30-day time periods are represented as months" so 360 days = 12 months = 1 year so 365 days is 1-year 5-days. There are all sorts of oddities and special assumptions regarding date/time calculations made even more complicated by the need to

Re: [DOCS] Indicated Epoch 0 is incorrect

2016-06-07 Thread Steve Crawford
The docs are correct. When you convert a string to a timestamp with time zone it will interpret the string in *your* time zone which is apparently offset from UTC. Try: select extract(epoch from timestamp with time zone '1970-01-01 00:00:00-00'); or select extract(epoch from timestamp with time