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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
