On 03-05-2021 13:13, Adriano dos Santos Fernandes wrote:
On 03/05/2021 07:51, Mark Rotteveel wrote:
Is there a way to obtain the current time zone of a session? I looked at
RDB$GET_CONTEXT, MON$DATABASE and MON$ATTACHMENTS, but I can't find such
a feature. Am I overlooking something or does this not exist yet?
If you are not against SUBSTRING:
substring(current_timestamp from 26)
Perhaps we should add non-standard extension to EXTRACT to complement
TIMEZONE_HOUR/TIMEZONE_MINUTE returning the region or [+/-]HH:MM offset
as string.
That sounds as a workaround. I was more looking for a formal method of
obtaining the session time zone, e.g. `rdb$get_context('SYSTEM',
'SESSION_TIME_ZONE')`, and maybe MON$TIME_ZONE in MON$ATTACHMENTS.
Having such an option would be equivalent to `rdb$get_context('SYSTEM',
'SESSION_IDLE_TIMEOUT')` and MON$IDLE_TIMEOUT in MON$ATTACHMENTS.
I'll create a ticket to that effect.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
