ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST) : Time Zone « Date Timezone « Oracle PL / SQL






ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST)


SQL>
SQL> --ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST):
SQL>
SQL> ALTER SESSION SET TIME_ZONE = 'PST';

Session altered.

SQL>
SQL>
           
       








Related examples in the same category

1.Time zone name
2.Select the current time zone
3.Timestamp with local time zone as a table column
4.Time change from Chicago to Los Angeles(Central to Pacific)
5.Obtaining Time Zone Names
6.TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP