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

Re: UTC timestamp

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: UTC timestamp
Date: 2009-12-16 12:08:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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.


When angry, count four; when very angry, swear.
		-- Mark Twain, "Pudd'nhead Wilson's Calendar"

In response to


pgsql-novice by date

Next:From: Josep Sanchez MesegueDate: 2009-12-16 21:09:29
Subject: Josep Sanchez Mesegue wants to stay in touch on LinkedIn
Previous:From: Jasen BettsDate: 2009-12-16 11:59:04
Subject: Re: UTC timestamp

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