On 03/06/2018 05:32, Mark Rotteveel wrote: > >> Function DATABASE_VERSION >> >> ----------- >> SQL> select rdb$time_zone_util.database_version() from rdb$database; >> >> DATABASE_VERSION >> ================ >> 2017c >> ----------- > > Minor nitpick: the current db is 2018e. >
The one present in Ubuntu Bionic is 2017c. A way to configure updated database is really needed. >> It worth discuss the name conversion. Should it be prefixed by GET_ >> (DATABASE_VERSION)? > > I think it is fine to leave that off. > >> Procedure TRANSITION_RULES >> >> ----------- >> SQL> set list on; >> SQL> >> SQL> select * from rdb$time_zone_util.transition_rules( >> CON> 'America/Sao_Paulo', >> CON> date '2016-01-01', >> CON> date '2019-12-31'); >> >> RULE_START 2015-10-18 03:00:00.0000 GMT >> RULE_END 2016-02-21 01:59:59.9999 GMT >> ZONE_OFFSET -180 >> DST_OFFSET 60 > > I find this a bit confusing. If I'm interpreting it right, this means > the actual zone offset is -120. Maybe add an extra column > EFFECTIVE_OFFSET (or something like that). Presence of that could make > it more self-explanatory. > Maybe. Since then, I have did others changes. Procedure name TRANSITION_RULES is renamed to TRANSITIONS. Rules are another thing, it's how the transitions are specified in the tzdb. It may be added at another time. Output columns RULE_START and RULE_END is renamed to INITIAL_TIMESTAMP and FINAL_TIMESTAMP. 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
