Re: [Firebird-devel] Time zone feature documentation

2018-07-22 Thread Adriano dos Santos Fernandes
On 22/07/2018 13:14, Mark Rotteveel wrote: > On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Here is the first README version for the time zone feature. >> >> https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md >> > > I

Re: [Firebird-devel] Time zone feature documentation

2018-07-22 Thread Mark Rotteveel
On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: Hi! Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md I just took another look, the format for

Re: [Firebird-devel] Time zone feature documentation

2018-05-20 Thread Adriano dos Santos Fernandes
On 20/05/2018 08:25, Mark Rotteveel wrote: > On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Here is the first README version for the time zone feature. >> >> https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md >> >> > >

Re: [Firebird-devel] Time zone feature documentation

2018-05-20 Thread Mark Rotteveel
On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: Hi! Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md Will it be possible to set the session timezone on connect

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Lester Caine
On 12/05/18 15:28, Adriano dos Santos Fernandes wrote: The discussion is going to a place that the next part will be about time zones as we know not works outside of Earth. The current offering is not practical in a number of current real world applications! And the same is true of other

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Dimitry Sibiryakov
12.05.2018 16:24, Adriano dos Santos Fernandes wrote:   In decode/encode functions what fractions are used? Is it Firebird legacy fractions in 1/1 of a second or standard fractions in 1/10 of a second? Same as with the WITHOUT tz types. Isn't it better to support a standard

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Adriano dos Santos Fernandes
On 12/05/2018 06:02, Lester Caine wrote: > > In part I can accept that, but short cuts need to be documented? It is > not common knowledge that TZ data IS questionable prior to 1970, and > with the amount of research being done on even just the second world > war, knowing that time one is

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Adriano dos Santos Fernandes
On 12/05/2018 05:51, Dimitry Sibiryakov wrote: > 11.05.2018 18:31, Adriano dos Santos Fernandes wrote: >> Here is the first README version for the time zone feature. > >   In decode/encode functions what fractions are used? Is it Firebird > legacy fractions in 1/1 of a second or standard

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Lester Caine
On 12/05/18 07:43, Mark Rotteveel wrote: Like Macau, a lot of historic data has been added and for databases handling historic material it would be nice if there was a way to have matching correct offsets? Or we ignore the builtd in tools and cintinue to rely on external functions ... To

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Dimitry Sibiryakov
11.05.2018 18:31, Adriano dos Santos Fernandes wrote: Here is the first README version for the time zone feature. In decode/encode functions what fractions are used? Is it Firebird legacy fractions in 1/1 of a second or standard fractions in 1/10 of a second? I see no

Re: [Firebird-devel] Time zone feature documentation

2018-05-12 Thread Mark Rotteveel
On 12-5-2018 02:25, Lester Caine wrote: On 12/05/18 00:32, Adriano dos Santos Fernandes wrote: On 11/05/2018 19:48, Lester Caine wrote: There is no information on those pages covering just what way the base TZ data is processed. I think it is probably safe to assume that it is unusable for

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 12/05/18 00:32, Adriano dos Santos Fernandes wrote: On 11/05/2018 19:48, Lester Caine wrote: There is no information on those pages covering just what way the base TZ data is processed. I think it is probably safe to assume that it is unusable for providing timezone offsets prior to 1970

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Adriano dos Santos Fernandes
On 11/05/2018 19:48, Lester Caine wrote: > > There is no information on those pages covering just what way the base > TZ data is processed. I think it is probably safe to assume that it is > unusable for providing timezone offsets prior to 1970 which is the > current target of TZ itself, so it

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 11/05/18 23:32, Vlad Khorsun via Firebird-devel wrote: 12.05.2018 1:12, Lester Caine wrote: On 11/05/18 20:37, Adriano dos Santos Fernandes wrote: * PST is Pitcairn or Pacific, with the same offset, they are considered different time zones ICU data is derived from TZ data hosted by IANA

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Vlad Khorsun via Firebird-devel
12.05.2018 1:12, Lester Caine wrote: On 11/05/18 20:37, Adriano dos Santos Fernandes wrote: * PST is Pitcairn or Pacific, with the same offset, they are considered different time zones ICU data is derived from TZ data hosted by IANA (http://site.icu-project.org/tznotice). I really can't

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 11/05/18 20:37, Adriano dos Santos Fernandes wrote: * PST is Pitcairn or Pacific, with the same offset, they are considered different time zones ICU data is derived from TZ data hosted by IANA (http://site.icu-project.org/tznotice). I really can't answer questions about specific time

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Adriano dos Santos Fernandes
On 11/05/2018 16:04, Mark Rotteveel wrote: > On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Here is the first README version for the time zone feature. >> >> https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md >> > >

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Mark Rotteveel
On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: Hi! Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md Reading through that, a few questions: # About the 2 bytes for

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Lester Caine
On 11/05/18 17:31, Adriano dos Santos Fernandes wrote: Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md So there is no provision to support the initial LMT offsets for those

[Firebird-devel] Time zone feature documentation

2018-05-11 Thread Adriano dos Santos Fernandes
Hi! Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md Adriano -- Check out the vibrant tech