On Wed, Jan 25, 2012 at 07:37:44AM -0800, Adrian Klaver wrote: > Its not the extract part but the at time zone part see: > > http://www.postgresql.org/docs/9.0/interactive/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT not sure what you mean - timestamptz at time zone converts to timestamp (without time zone), and it shows predictable results: $ begin; BEGIN *$ set timezone = 'EST'; SET *$ select now() at time zone 'UTC'; timezone ──────────────────────────── 2012-01-25 15:43:31.048171 (1 row) *$ set timezone = 'CET'; SET *$ select now() at time zone 'UTC'; timezone ──────────────────────────── 2012-01-25 15:43:31.048171 (1 row) both timestamps returned are the same. Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
