Re: to_timestamp returns the incorrect result for the DST fall over time. - Mailing list pgsql-bugs

Gouse <gkhaji@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