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';