There are requests to implement Time zones in Firebird:
http://tracker.firebirdsql.org/browse/CORE-694
http://tracker.firebirdsql.org/browse/CORE-909
These two are in the "Optional features" list for Firebird 4:
https://www.firebirdsql.org/en/planning-board/
Best Regards
Stefan
--
Stefan H
If I may be permitted to stick my oar in here
Oracle databases allow timestamp with timezone data types, as well as simple
timezone data types. Every database I've come across in my day job, I'm an
Oracle contract DBA, uses either date (aka date and time) or simple timezone
data types.
On 12/01/17 14:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Can someone point me in the right direction please?
There have been many attempts to justify storing a time stamp complete
with timezone directly in a time field, but the real answer is that it
is always wrong. Store location
12.01.2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Can someone point me in the right direction please?
Firebird does not handle time zones at all. CURRENT_TIMESTAMP and
CURRENT_TIME return
local time.
--
WBR, SD.
-
On 12-1-2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Sorry if this is a really basic question, but some time spent searching
> has failed to find for me the definitive detailed documentation on
> exactly how Firebird handles time zones (I'm particularly interested, to
> start w
Sorry if this is a really basic question, but some time spent searching
has failed to find for me the definitive detailed documentation on
exactly how Firebird handles time zones (I'm particularly interested, to
start with, in using CURRENT_TIMESTAMP to create a value in a TIMESTAMP
field, and