> On 10 May 2018, at 15:12, Vick Khera <vi...@khera.org> wrote: > > On Thu, May 10, 2018 at 7:31 AM, Ben Hood <b...@relops.com > <mailto:b...@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.
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.