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: 4B28CDA1.4090103@gmail.com (view raw or flat)
Thread:
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

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!

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group