On 10/4/15 6:18 AM, Karsten Hilbert wrote:
> check whether both TZs are equal,
> if so
> ignore them
> else
> convert both operands to UTC,
> do "time - time",
> return result AT TIME ZONE UTC,
> document that UTC is returned,
>
> such that the user can know to apply "AT TIME ZONE ..."
> to the result as needed.
The problem there is you can't reliably convert a time to a different
timezone without knowing what date you're talking about.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com