But how timezone settup is configured in FB4?
Time zone is set in fbconfig (preffered) or is retrived from system?
If from config, then CURRENT_DATE and LOCAL_TIMESTAMP will get different date
when different timezone setting is in config and on the server.
regards,
Karol Bieniaszewski
From:
On 2018-07-17 16:43, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>>> ANSI standard compliance is the answer for all questions
>
> What about last question LOCAL_DATE missed?
The SQL standard only knows a single DATE type (there is no DATE WITH
TIME ZONE type), so there
Hello,
I come back because I've upgrade Firebird to 2.5.8 but the problem of
creating foreign keys always persists.
In fact, the problem occurs after executing commands for insert, update and
delete data and after that I exectue command to create FK.
I've found that when I've two or more FK for
17.07.2018 14:21, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> the questions:
ANSI standard compliance is the answer for all questions.
--
WBR, SD.
Hi,
as this is forwarded to FB3 i ask on support group not devel.
Now we have CURRENT_TIME, CURRENT_TIMESTAMP which get time from server whitout
timezone.
Why you breake backward compatibility in FB4 (FB3 is still ok)?
In FB4 "old" FB3 identifiers
CURRENT_TIME will be LOCAL_TIME