Skip site navigation (1) Skip section navigation (2)

Re: UTC timestamp

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: UTC timestamp
Date: 2009-12-17 07:03:25
Message-ID: hgcl3t$ldd$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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
> Ok
>> 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.
> Thanks!

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. BarbierDate: 2009-12-17 08:25:42
Subject: Re: UTC timestamp
Previous:From: Josep Sanchez MesegueDate: 2009-12-16 21:09:29
Subject: Josep Sanchez Mesegue wants to stay in touch on LinkedIn

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group