On 01/23/2017 05:01 PM, David G. Johnston wrote:
On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
