On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver <adrian.kla...@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... David J.
