On 18/07/2018 14:48, livius wrote: > Hi, > > moved from support list as requested by Mark Rotteveel > > question about timezone support in FB4. > How “current” timezone is configurred? Is it retrived from system or > from Firebird config? > I suppose that both configuration should be possible it will be more > flexible. > We then can have multiple FB installation on same server with > different timezone settings. > This is required especially for shared hostings. >
Please see about session time zone and CURRENT_TIME/CURRENT_TIMESTAMP in the documentation: https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md > But if it can be set in firebird.conf then CURRENT_DATE is not enought > to have. > Should be also introduced LOCAL_DATE. Why? > Because CURRENT_DATE will be different of CAST(LOCAL_TIMESTAMP AS > DATE) if system time zone is different then in the config. > Per the standard, CURRENT_DATE is the date part of LOCALTIMESTAMP, so there is no LOCALDATE. 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
