SQL>
SQL> CREATE TABLE purchases_timestamp_with_tz (
2 product_id INTEGER,
3 customer_id INTEGER,
4 made_on TIMESTAMP(4) WITH TIME ZONE
5 );
Table created.
SQL>
SQL> INSERT INTO purchases_timestamp_with_tz (product_id, customer_id, made_on)
2 VALUES (1, 1, TIMESTAMP '2005-05-13 07:15:31.1234 -07:00');
1 row created.
SQL>
SQL> INSERT INTO purchases_timestamp_with_tz (product_id, customer_id, made_on)
2 VALUES (1, 2, TIMESTAMP '2005-05-13 07:15:31.1234 PST');
1 row created.
SQL>
SQL> SELECT * FROM purchases_timestamp_with_tz;
PRODUCT_ID CUSTOMER_ID MADE_ON
---------- ----------- ---------------------------------------------------------------------------
1 1 13-MAY-05 07.15.31.1234 AM -07:00
1 2 13-MAY-05 07.15.31.1234 AM PST
SQL>
SQL>
SQL> drop table purchases_timestamp_with_tz;
Table dropped.
SQL>