Mega Code Archive
Timestamp with local time zone as a table column
<![CDATA[
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>
]]>