Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

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: Mark

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

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 is

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

>>ANSI standard compliance is the answer for all questions What about last question LOCAL_DATE missed? Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Error creating Foreign key

17.07.2018 16:04, Mourad Hedfi mou...@bilog.fr [firebird-support] wrote: > I've added a transaction and I've command FK executed successfully but when I > commit > transaction, I've the following error " Unable to complete network request to > host > "localhost ". - Error wri

Re: [firebird-support] Re: Error creating Foreign key

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

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

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. ++

[firebird-support] LOCALTIME and LOCALTIMESTAMP

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 CURRENT_TIME