On 08/07/2020 14:44, Dimitry Sibiryakov wrote:
08.07.2020 15:32, Adriano dos Santos Fernandes wrote:
I personally think TIME-TZ with regions are a valid thing (albeit weird
depending on the operations) because it fills a gap where one creates a
TIME and a additional region column. TIME-TZ with offsets only (no
regions) does not have the weird things by definition, but weird things
will happen when converting from timestamps.
SQL 2003 standard supports only offsets in TIME WITH TIME ZONE, not
region names.
And the standard has been wrong since it was first published ... it
ignored DST management simply because it was too difficult to include.
--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
