TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP : Time Zone « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. Time Zone

TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP



SQL>
SQL> -- TIME_ZONE to EST and repeat the previous query
SQL>
SQL> ALTER SESSION SET TIME_ZONE = 'EST';

Session altered.

SQL>
SQL> SELECT CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP FROM dual;

CURRENT_TIMESTAMP                                                           LOCALTIMESTAMP
--------------------------------------------------------------------------- ---------------------------------------------------------------------------
SYSTIMESTAMP
---------------------------------------------------------------------------
16-SEP-06 08.35.53.046000 PM EST                                            16-SEP-06 08.35.53.046000 PM
16-SEP-06 05.35.53.046000 PM -07:00


SQL>
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.ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST)