On 01/23/2017 05:14 PM, David G. Johnston wrote:
On Mon, Jan 23, 2017 at 6:08 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>wrote: production=# show timezone; TimeZone ---------- UTC (1 row) production=# select ' 2011-01-01 00:00:03.925-06'::timestamptz < '2011-01-01'::date; ?column? ---------- f What Tom said - though I missed the part about "the timezone when the data was entered" - I was thinking it was only the timezone at the time of the dump that would impact things. To your example - testing in UTC is going to always result in failure for Z values <= 0 since they will all result in a UTC date of 2011-01-01. Choosing +06 would result in a passed test.
That was sort of the point, I was just using the value that the OP said worked:
"if change 2011-01-01 00:00:03.925+00 to 2011-01-01 00:00:03.925-06 works ok"
I could not see how it did.
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
