关于设置会话时区

The ORA_SDTZ environment variable can be set to thefollowing values:

To set ORA_SDTZ, use statements similar to one ofthe following in a UNIX environment (C shell):

% setenv ORA_SDTZ 'OS_TZ'
% setenv ORA_SDTZ 'DB_TZ'
% setenv ORA_SDTZ '-05:00'
% setenv ORA_SDTZ 'Europe/London'

You can change the time zone for a specific SQL sessionwith the SET TIME_ZONE clause of the ALTERSESSION statement.

TIME_ZONE can be set to the followingvalues:--TIME_ZONE可以设置为下列值：

• Default local time zone when the session was started(local)

• Database time zone(dbtimezone)

• Absolute offset from UTC (for example,'+10:00')

• Time zone region name (for example,'Asia/Hong_Kong')

Use ALTER SESSION statements similar to thefollowing:

ALTER SESSION SET TIME_ZONE=local;
ALTER SESSION SET TIME_ZONE=dbtimezone;
ALTER SESSION SET TIME_ZONE='+10:00';
ALTER SESSION SET TIME_ZONE='Asia/Hong_Kong';

You can find out the current session time zone by entering thefollowing query:

SELECT sessiontimezone FROM DUAL;