Re: Get server's time in UTC time zone, in ISO 8601 format - Mailing list pgsql-novice

On 12/01/10 22:03, Basil Bourque wrote:
>    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)



select (current_timestamp at time zone 'ZULU')||'+00';