On 14-6-2019 15:25, Vlad Khorsun wrote:
14.06.2019 16:17, Adriano dos Santos Fernandes wrote:
Do you even worked with a library doing datetime logic in a way suitable
for multiple time zones?
Every one stores the UTC time more the region _or_ offset. The
displayable value is calculated only when one wants to display the value.
This is exactly what i want. The only difference with current state
of things is to move that calculation from client to the server - at
the moment when it returns\receives data to\from client.
And that is not really workable if the client does want to use offset
based values and for example doesn't know the zone Firebird uses, or if
Firebird uses an offset that is too large.
This is only a solution for ad-hoc querying, and if you want that, then
set the time zone bind to legacy and you'll get this feature for free.
The current solution is a trade off, but having the UTC value clientside
is the only guarantee that the client gets a usable and meaningful value
under all circumstances.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
