14.5. Time Zone Management

Statements for management of time zone features of the current connections.

14.5.1. SET TIME ZONE

Used forChanging the session time zone

Available inDSQL, PSQL

Syntax 

  |SET TIME ZONE { time_zone_string | LOCAL }

Changes the session time zone to the specified time zone. Specifying LOCAL will revert to initial session time zone of the session (either the default or as specified through connection property isc_dpb_session_time_zone).

Executing Section 14.6.1, “ALTER SESSION RESET” has the same effect on the session time zone as SET TIME ZONE LOCAL, but will also reset other session properties.

14.5.1.1. SET TIME ZONE Examples

  |set time zone '-02:00';
  |set time zone 'America/Sao_Paulo';
  |set time zone local;