Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-7-2018 15:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > >>I suggest you take this question to the firebird-devel mailing list as > >>it concerns an unreleased version. Questions on FB4 are off topic here. > > >>Mark > > Yes, but as local_time and

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.07.2018 15:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Yes, but as local_time and local_timestamp was forwarded to FB3 it is > important to know if > we need also Local_date as replacement to Current_date in FB3. Then we must > know FB4 TZ > configuration

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
>>I suggest you take this question to the firebird-devel mailing list as >>it concerns an unreleased version. Questions on FB4 are off topic here. >>Mark Yes, but as local_time and local_timestamp was forwarded to FB3 it is important to know if we need also Local_date as replacement to

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 18/07/18 09:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I suggest you take this question to the firebird-devel mailing list as > it concerns an unreleased version. Questions on FB4 are off topic here. Although the corner cutting being taken in the current

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-07-17 18:39, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote: > 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

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-17 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Sent: Tuesday, July 17, 2018 5:38 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP On 2018-07-17 16:43, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >>> ANSI

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP

2018-07-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

2018-07-17 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
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