Re: Format string for ISO-8601 date and time

Sam Mason wrote:

> 1) values of type "timestamp with time zone" are always converted
> to UTC (either using the timezone specified or using the session's
> current "timezone" value) and then when they're sent back to the
value
> is then corrected to the session's timezone (or an explicit AT TIME
> ZONE can be specified).
>
> 2) values of type "timestamp without time zone" (or alternatively
> spelled just "timestamp") ignore any timezone specified and assume
the
> value is UTC.
>
> I find it all quite confusing (and hence the above may be wrong) but
> have the luxury of ignoring it as all as my users are in the same
> timezone. That said, it's a useful set of abstractions as lots of
> people use them regularly.

Thanks, I was aware already that "timestamp with time zone" doesn't
store any timezone contrary to what its name seems to imply. (Though
when I first started with PG some years ago, I sure fell in that trap)

Best regards,

--
Daniel