Re: Get server's time in UTC time zone, in ISO 8601 format

Basil Bourque <basil.list@me.com> writes:
> -->  How to get the server's time in UTC time zone ('ZULU'), in ISO 8601 format, by executing a simple SELECT
statement?

You already found it:

>   select current_timestamp AT TIME ZONE 'ZULU'
> That does indeed give me the UTC time, but without a timezone on the end such as +00 or z or zulu:
>   2010-12-02 00:29:05.735597
> Note the lack of +00 on end (that's a bad thing)

Why do you need that?  You told it what time zone you wanted.

            regards, tom lane