Gouse <gkhaji(at)gmail(dot)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