Basil Bourque <basil(dot)list(at)me(dot)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