Use 'TIMESTAMP(4) WITH LOCAL TIME ZONE' as column type : Timestamp Timezone « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Timestamp Timezone

SQL>
SQL> CREATE TABLE localtimezone (
  2  id integer,
  3  made_on TIMESTAMP(4) WITH LOCAL TIME ZONE);

Table created.

SQL>
SQL> INSERT INTO localtimezone (id, made_on) VALUES (1,TIMESTAMP '2005-05-13 07:15:30 EST');

1 row created.

SQL>
SQL> SELECT *
  2  FROM localtimezone;

        ID MADE_ON
---------- ---------------------------------------------------------------------------
         1 13-MAY-05 04.15.30.0000 AM

SQL>
SQL> Drop table localtimezone;

Table dropped.

SQL>