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. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel