Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
-----------------------------------------------------------
Key: CORE-5853
URL: http://tracker.firebirdsql.org/browse/CORE-5853
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Adriano dos Santos Fernandes
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
