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>
|