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 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 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 no need to distinguish between CURRENT_DATE and LOCALDATE. Mark