| Subject | Re: [firebird-support] LOCALTIME and LOCALTIMESTAMP |
|---|---|
| Author | livius |
| Post date | 2018-07-17T16:39:54Z |
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
Sent: Tuesday, July 17, 2018 5:38 PM
Subject: Re: [firebird-support] LOCALTIME and
LOCALTIMESTAMP
On 2018-07-17 16:43, liviuslivius liviuslivius@...
[firebird-support] wrote:
>>> ANSI standard compliance is theanswer for all questions
>missed?
> What about last question LOCAL_DATE
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