TIMESTAMP(4) WITH TIME ZONE : Timestamp « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. Timestamp

TIMESTAMP(4) WITH TIME ZONE

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>
           
       

Related examples in the same category