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>