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