Re: Domain based on TIMEZONE WITH TIME ZONE

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE
Date: 2018-05-10 14:12:30
Message-ID: CALd+dcdCxk00TnL0ey_1Yk-egwwqFjF3BJbiA_=8aJwSjWP6Yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 10, 2018 at 7:31 AM, Ben Hood <ben(at)relops(dot)com> wrote:

> Or are we saying that domains are one way of achieving the timestamp
> hygiene, but equally, you can get the same result as described above?
>

The *only* way to have timestamp hygiene is to require them to have time
zones at all times, even if that time zone is UTC. Any other representation
of a time is ambiguous without context.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2018-05-10 14:17:21 Re: Domain based on TIMEZONE WITH TIME ZONE
Previous Message Adrian Klaver 2018-05-10 13:58:22 Re: Why is my Postgre server went in recovery mode all in sudden