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 ju
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 isc_dpb_session_time_zone
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
>>
>>
>
> W
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 throug
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 datab
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 nin
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 normali
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 fract
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 be
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 mention
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 pro
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 whi
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 wo
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
(h
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 answe
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 zones,
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
>>
>
> Readi
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 th
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
r
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 communit
20 matches
Mail list logo