Timestamp with local time zone as a table column



SQL> create table local_conference_calls (
  2        title   varchar2(100),
  3        phone   varchar2(20),
  4        place   varchar2(100),
  5        starts  timestamp with local time zone)
  6      /

Table created.

SQL>
SQL> insert into local_conference_calls (title, phone, place, starts)
  2      values ('Sales Strategy', '212.123.4567', 'New York',
  3              TIMESTAMP '2001-12-01 15:00:00.000000 EST')
  4     /

1 row created.

SQL>
SQL>
SQL> insert into local_conference_calls (title, phone, place, starts)
  2      values ('Product Features', '650.123.4567', 'San Francisco',
  3              TIMESTAMP '2001-12-01 17:00:00.000000 PST')
  4    /

1 row created.

SQL>
SQL> insert into local_conference_calls (title, phone, place, starts)
  2      values ('Football Highlights', '44 1234 5678', 'London',
  3              TIMESTAMP '2001-12-01 20:00:00.000000 GMT')
  4     /

1 row created.

SQL>
SQL> select * from local_conference_calls;

TITLE                                                                                                PHONE
---------------------------------------------------------------------------------------------------- --------------------
PLACE                                                                                                STARTS
---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------
Sales Strategy                                                                                       212.123.4567
New York                                                                                             01-DEC-01 01.00.00.000000 PM

Product Features                                                                                     650.123.4567
San Francisco                                                                                        01-DEC-01 06.00.00.000000 PM

Football Highlights                                                                                  44 1234 5678
London                                                                                               01-DEC-01 01.00.00.000000 PM


SQL>
SQL> drop table local_conference_calls;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Time zone name
2.	Select the current time zone
3.	Time change from Chicago to Los Angeles(Central to Pacific)
4.	Obtaining Time Zone Names
5.	ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST)
6.	TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP

Timestamp with local time zone as a table column : Time Zone « Date Timezone « Oracle PL / SQL

Related examples in the same category