On 2020-05-18 13:31, Adriano dos Santos Fernandes wrote:
Do you have an alternative (that do not broke things), better than use
fixed date (as Oracle does with 0001-01-01 and it even more broke
behavior) or a recent date?
Telling true I have bug desire to answer that error 'Invalid
operation' should be raised because operation is really invalid, it
has undefined result (something near to zerodivide). But I'm afraid
users do not like such suggestion...
If you talk only about conversion between region-based times/tz and
timestamps or time without time zone, maybe...
About usage of region-based times/tz and comparison with others
region-based times/tz, I think the current behavior is ok. It's not
perfect, but not very problematic. It's better to allow people to use
region-based times/tz (to say things as "that event happens in that time
of given country every day") than do not.
Yes, for comparison needs it's almost OK - at least I do not see any
better approach.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
