Hello All.
I'm trying to get current timestamp without time zone in UTC without messing with
session settings but... I cannot figure out how to.
"localtimestamp" results in timestamp in current time zone.
"localtimestamp at time zone 'UTC'" results in timestamp with time zone.
"cast(localtimestamp at time zone 'UTC' as timestamp without time zone)" results in
timestamp in current time zone again.
Syntax "cast(current_timestamp as timestamp without time zone at time zone 'UTC')" does
not exist.
Any idea?
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel