On 08/07/2020 10: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. >
As well as in timestamp, which make standard TIMESTAMP WITH TIME ZONE almost useless for real applications. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel