On 4/23/19 6:45 PM, Adriano dos Santos Fernandes wrote:
Hi!
With time zones, there is some timestamps that does not exist or are
"ambiguous".
For example, timestamp '2017-10-15 00:00 America/Sao_Paulo' does not
exist as it's in the gap where DST starts and had one hour advanced.
And timestamp '2018-02-17 23:00 America/Sao_Paulo' are ambiguous as it
may be before DST ended or just after it.
In Firebird currently the first case is treated as the valid hour before it.
The second case is treated as the "second hour", i.e., the hour after
DST ended.
I'm fine with the second case (I think an exception would be worse) but
IMO the first case of invalid time is better treated with an exception.
What do you think?
Adriano, I'm afraid that this task does not have good logical solution
(like everything related with DST). The only reasonable way it to try
and see what others do.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
