>
> Again looking at the documentation, we see that "timestamp with
> time zone AT TIME ZONE zone" means "Convert UTC to local time in
> given time zone" and has a return type of "timestamp without time
> zone". So if we run the above command without the final cast
> around 16:25 PDT / 23:25 UTC, we get this:
>
> SELECT timezone('UTC', timeofday()::timestamptz);
> timezone
> ----------------------------
> 2005-04-21 23:25:12.868212
> (1 row)
>
> This result is a "timestamp without time zone", so there's no
> indication that it's UTC or PDT or anything else. Since it has no
> time zone, casting it to timestamptz puts it in your local time
> zone:
>
> SELECT '2005-04-21 23:25:12.868212'::timestamptz;
> timestamptz
> -------------------------------
> 2005-04-21 23:25:12.868212-07
> (1 row)
Okay, I understand what you're saying now, but then is a time without a
timezone implicitly assumed to be UTC? Is there a way to explicitly make the
timezone on the stamp be UTC, if the prior is not the case?
Steve
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
