Issue Details (XML | Word | Printable)

Key: CORE-5853
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 2
Operations

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

Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP

Created: 20/Jun/18 03:58 PM   Updated: 21/Sep/18 05:15 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0.4, 2.5.9

QA Status: Done with caveats
Test Details:
Empty code remains for 4.0 section in .fbt: waiting for merging this new feature in master.


 Description  « Hide
In version 4.0, Firebird will support time zones.

Within this support will come an incompatibility with previous versions' `CURRENT_TIME` and `CURRENT_TIMESTAMP` expressions.

In v4, `CURRENT_TIME` and `CURRENT_TIMESTAMP` will respectively return expressions of data type `TIME WITH TIME ZONE` and `TIMESTAMP WITH TIME ZONE`.

To make your queries and database code compatible with future versions, from v3.0.4 you can instead use `LOCALTIME` and `LOCALTIMESTAMP`. In v3, these `LOCAL*` expressions will work indenticaly to their correspondents `CURRENT_*` expressions.

In v4, `LOCAL*` expressions will continue to work identically as now, but the `CURRENT_*` expressions will change.

You should not start using `LOCALTIME` and `LOCALTIMESTAMP` if your database may be downgraded to v3.0.3 or another version, as the old versions will not recognize the new expressions.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 20/Jun/18 04:00 PM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 11/Jul/18 04:37 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0.4 [ 10863 ]
Resolution Fixed [ 1 ]
Adriano dos Santos Fernandes made changes - 25/Jul/18 04:11 PM
Fix Version/s 2.5.9 [ 10862 ]
Pavel Zotov made changes - 31/Jul/18 11:26 AM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Waiting for reply on note 31/Jul/18 11:19 AM
QA Status No test Deferred
Pavel Zotov made changes - 31/Jul/18 08:46 PM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Waiting for reply on note 31/Jul/18 11:19 AM Empty code remains for 4.0 section in .fbt: waiting for merging this new feature in master.
QA Status Deferred Done with caveats