Gouse <gkh...@gmail.com> wrote: > I am afraid this may not give the result I am looking for. It sounds like you didn't even try it. That's bad form. I'm wondering why you bring to_timestamp into it at all, though. Are you aware of the behavior of casting?: test=# select '2011-01-15 00:00:00.0 UTC'::timestamptz; timestamptz ------------------------ 2011-01-14 18:00:00-06 (1 row) If you put together a string with the UTC timezone specified, and cast it to timestamptz, I think you'll get what you want. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs