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.


Adriano



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to