Re: Domain based on TIMEZONE WITH TIME ZONE - Mailing list pgsql-general

From Vick Khera
Subject Re: Domain based on TIMEZONE WITH TIME ZONE
Date
Msg-id CALd+dcdCxk00TnL0ey_1Yk-egwwqFjF3BJbiA_=8aJwSjWP6Yw@mail.gmail.com
Whole thread Raw
In response to Re: Domain based on TIMEZONE WITH TIME ZONE  (Ben Hood <ben@relops.com>)
Responses Re: Domain based on TIMEZONE WITH TIME ZONE  (Ben Hood <ben@relops.com>)
List pgsql-general
On Thu, May 10, 2018 at 7:31 AM, Ben Hood <ben@relops.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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE
Next
From: Karsten Hilbert
Date:
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE