Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-19 Thread Mark Rotteveel
On 2018-07-18 22:51, livius wrote: Hi, thank you for the link. If i understand correctly then all functions "CURRENT_..." and "LOCAL_..." result are in session TZ? Note that it is LOCALTIME and LOCALTIMESTAMP, so no underscore there. If yes, then now it is much clearer, I thought that

Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread livius
Hi, thank you for the link. If i understand correctly then all functions "CURRENT_..." and "LOCAL_..." result are in session TZ? If yes, then now it is much clearer, I thought that "CURRENT_" state for server time zone retrieved from e.g. system and "LOCAL_" was for database timezone or

Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread Adriano dos Santos Fernandes
On 18/07/2018 14:48, livius wrote: > Hi, >   > moved from support list as requested by Mark Rotteveel >   > question about timezone support in FB4. > How “current” timezone is configurred? Is it retrived from system or > from Firebird config? > I suppose that both configuration should be possible

[Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-18 Thread livius
Hi, moved from support list as requested by Mark Rotteveel question about timezone support in FB4. How “current” timezone is configurred? Is it retrived from system or from Firebird config? I suppose that both configuration should be possible it will be more flexible. We then can have multiple