TIMESTAMP WITH TIME ZONE type extends TIMESTAMP to allow you to store a time zone
SQL>
SQL> --TIMESTAMP WITH TIME ZONE type extends TIMESTAMP to allow you to store a time zone.
SQL>
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> desc purchases_timestamp_with_tz;
Name Null? Type
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
PRODUCT_ID NUMBER(38)
CUSTOMER_ID NUMBER(38)
MADE_ON TIMESTAMP(4) WITH TIME ZONE
SQL>
SQL> drop table purchases_timestamp_with_tz;
Table dropped.
SQL>
SQL>
Related examples in the same category