Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>