Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-21 Thread Lester Caine
On 21/01/2019 09:21, Alex Peshkoff via Firebird-devel wrote: That means you have old ICU. Should be something like: SQL> select rdb$time_zone_util.database_version()   from rdb$database; DATABASE_VERSION 2012j One would hope that it would return a 2018 version at least 2018i

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-21 Thread Adriano dos Santos Fernandes
On 20/01/2019 20:42, Jorge Gonçalves wrote: > I'm using Firebird-4.0.0.1378-0_x64  and it seems that the timezone > database is missing  > > for example the statement  > "select rdb$time_zone_util.database_version()   from rdb$database;" > > returns  > DATABASE_VERSION > > Statemen

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-21 Thread Alex Peshkoff via Firebird-devel
On 1/21/19 1:42 AM, Jorge Gonçalves wrote: I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone database is missing for example the statement "select rdb$time_zone_util.database_version()   from rdb$database;" returns DATABASE_VERSION Statement failed, SQLSTATE =

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Jorge Gonçalves
I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone database is missing for example the statement "select rdb$time_zone_util.database_version() from rdb$database;" returns DATABASE_VERSION Statement failed, SQLSTATE = HY000 Error calling ICU's ucal_getTZDataVers

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Mark Rotteveel
On 2019-01-20 15:30, Jorge Gonçalves wrote: according to the time zone documentation the time_zone member in the ISC_TIME_TZ and ISC_TIMESTAMP_TZ structure returns the time zone identifier or displacement. There are any way to convert the time zone identifier to the displacement on the client si

[Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Jorge Gonçalves
Hi, according to the time zone documentation the time_zone member in the ISC_TIME_TZ and ISC_TIMESTAMP_TZ structure returns the time zone identifier or displacement. There are any way to convert the time zone identifier to the displacement on the client side ? jGoncalves Firebird-Devel mailing l