Hello 2009/2/26 Daniel Verite <dan...@manitou-mail.org>: > Hi, > > Is there a format string for to_char(timestamptz, text) that would output a > timestamp in full ISO-8601 format? That is, something like > 1977-04-22T01:00:00-05:00 > > I can't find a way to extract the offset against GMT from the docs here: > http://www.postgresql.org/docs/8.3/static/functions-formatting.html > > If not, what would be the way to convert a timestamp to such a string > regardless of the session's datestyle settings?
try to look on function extract, there you can get timezone from any timestamp with time zone. regards Pavel Stehule > > Thanks, > > -- > Daniel > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
