On 2009-12-16, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> Jasen Betts a écrit :
>> On 2009-12-14, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
>>> Hi list,
>>> For legal timestamping I'd like to record a timestamp in UTC,
>>> but I can't find a way to do that, is it possible?
>> timestamp with timezone (AKA timestamptz) is recorded in UTC
>> display format depends on client settings.
> Ah, I see now why my display wasn't correct: I thought it was the
> server, but it was the client missinterpreting.
you can alter the text form the sever gives
on a per-connection basis with
set time zone 'UTC';
or more permanently with
alter role "yourself" set time zone 'UTC';
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2009-12-17 08:25:42|
|Subject: Re: UTC timestamp|
|Previous:||From: Josep Sanchez Mesegue||Date: 2009-12-16 21:09:29|
|Subject: Josep Sanchez Mesegue wants to stay in touch on LinkedIn|