On 21/11/2017 14:42, Mark Rotteveel wrote: > > If you need that, you also need to store the actual timezone > somewhere. PostgreSQL for example also uses an offset for timestamp > with timezone (not sure if that is required by SQL standard though). > Each "TIMESTAMP-TZ" has a hour/minute offset associated with it. It does not only store an absolute value in GMT/UTC.
The offset can be EXTRACTed with TIMEZONE_HOUR / TIMEZONE_MINUTE. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
