Issue Details (XML | Word | Printable)

Key: CORE-6286
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Alexander Peshkov
Votes: 0
Watchers: 3

If you were logged in you would be able to see more operations.
Firebird Core

Make usage of TIMESTAMP/TIME WITH TIME ZONE convenient for users when appropriate ICU library is not installed on the client side

Created: 20/Apr/20 04:19 PM   Updated: 22/Apr/20 04:18 AM
Component/s: API / Client Library, Engine
Affects Version/s: 4.0 Beta 1
Fix Version/s: 4.0 Beta 2

QA Status: Done successfully

 Description  « Hide
Time (or timestamp - please keep it in mind here) with TZ is always sent to client using GMT. TZ information may be represented as offset (in that case converting GMT time to local one is not a problem) or zone code, and in this case mentioned conversion is problematic. Client library when can not convert GMT to local time is displaying time in original GMT form. People hate that behavior - they want to be able to get time in a zone as it was entered by default.

In order to solve that problem format extension is suggested - EXTENDED TIME WITH TIME ZONE. That form will have additional 2-byte field where offset of time zone is always placed by DB engine. Conversion of such datatype to local time on client is always trivial. The only place where that datatype may be used is SET BIND statement. To make things a little more flexible a generic 'EXTENDED' pseudo-datatype is also introduced as a target of SET BIND. When it's used (as target) an EXTENDED form of source datatype of SET BIND will be used as target.

And to make it even more flexible 'TIME ZONE' pseudo-datatype should be usable as source type of binding. When it's found in SET BIND that should make such SET BIND match any datatype containing time with time zone.

EXTENDED TIME WITH TIME ZONE should have support by fbclient API in order to perform conversions of that datatype.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.