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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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