Re: Domain based on TIMEZONE WITH TIME ZONE

[Ben Hood <ben@xxxxxxxxxx>]

On 10 May 2018, at 15:12, Vick Khera <vivek@xxxxxxxxx> wrote:

On Thu, May 10, 2018 at 7:31 AM, Ben Hood <ben@xxxxxxxxxx> 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.

That makes sense.

The motivation behind narrowing the built in TIMESTAMP WITH TIME ZONE down to a domain is to ensure the only permissible zone offset is UTC. This would be unambiguous.