On 02/06/2020 16:11, Mark Rotteveel wrote:
> The recent changes to fix the derivation of TIME WITH TIME ZONE to
> 2020-01-01 has weird consequences. In summer time, the value of for
> example CURRENT_TIME is now off by 1 hour when looking at the UTC time
> value.
>
> This leads to the following confusing results:
>
> SQL> set time zone 'Europe/Amsterdam';
> SQL> select current_time at time zone 'UTC' from rdb$database;
>
>                                             AT
> ==============================================
> 20:08:36.0000 UTC
>
> SQL> set time zone 'UTC';
> SQL> select current_time at time zone 'UTC' from rdb$database;
>
>                                             AT
> ==============================================
> 19:08:45.0000 UTC
>
> SQL> select current_time from rdb$database;
>
>                                   CURRENT_TIME
> ==============================================
> 19:08:52.0000 UTC
>
> SQL>
>
> Maybe it is better if CURRENT_TIME doesn't use the named zone, but
> instead always uses an offset based value.
>
I'm not sure it is. This would create other inconsistencies
(cast(current_timestamp as time with time zone) <> current_time).

There is no problem with a time with zone, the problem is when one uses
it to do things that depends on a date, like you did here.

Documentation should be improved for this case too.


Adriano



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to