Using the TIMESTAMP WITH TIME ZONE Type : Timestamp Timezone « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Timestamp Timezone

The TIMESTAMP WITH TIME ZONE type extends TIMESTAMP to allow you to store a time zone.

SQL> CREATE TABLE mytimestamptz (
  2    id INTEGER,
  3    made_on TIMESTAMP(4) WITH TIME ZONE
  4  );

Table created.

SQL>
SQL> INSERT INTO mytimestamptz (id, made_on) VALUES (
  2    1, TIMESTAMP '2005-05-13 07:15:31.1234 -07:00'
  3  );

1 row created.

SQL>
SQL> INSERT INTO mytimestamptz (id, made_on) VALUES (
  2    1,TIMESTAMP '2005-05-13 07:15:31.1234 PST'
  3  );

1 row created.

SQL>
SQL> SELECT * FROM mytimestamptz;

        ID MADE_ON
---------- ---------------------------------------------------------------------------
         1 13-MAY-05 07.15.31.1234 AM -07:00
         1 13-MAY-05 07.15.31.1234 AM PST

SQL>
SQL> drop table mytimestamptz;

Table dropped.

SQL>