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

Reply via email to