Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 05:01 PM, David G. Johnston wrote:
> On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>wrote:
>
>
>                 * this the  constraint:  "time_stamp_201012ad" CHECK
>         (time_stamp >=
>                 '2010-12-01'::date AND time_stamp < '2011-01-01'::date)
>
>                 if change 2011-01-01 00:00:03.925+00 to 2011-01-01
>                 00:00:03.925-06  works ok
>
>
>     Not seeing how?:
>
>     production=# show timezone;
>      TimeZone
>     ----------
>      UTC
>     (1 row)
>
>
>     production=# select ' 2011-01-01 00:00:03.925+00'::timestamptz  <
>     '2011-01-01'::date;
>      ?column?
>     ----------
>      f
>     (1 row)
>
>     production=# select ' 2011-01-01 00:00:03.925+00'::timestamptz  <
>     '2011-01-01'::date;
>      ?column?
>     ----------
>      f
>     (1 row)
>
>
> ​You failed to change the timezone to -06 in the second query...

Cut and paste error, what it should have been:

production=# show timezone;
  TimeZone
----------
  UTC
(1 row)

production=# select ' 2011-01-01 00:00:03.925-06'::timestamptz  <
'2011-01-01'::date;
  ?column?
----------
  f

>
> David J.
> ​


--
Adrian Klaver
adrian.klaver@aklaver.com