Re: Timezone Conversion

From: Phil <philip.moore_at_hp.com>
Date: 7 Jul 2005 10:49:21 -0700
Message-ID: <1120758561.356455.229550@g14g2000cwa.googlegroups.com>

Hi - sorry I jacked up the example :( - forgot a few things (I already had my time zone set to PST when I started it)

Here is the correct example:

philip_at_ORA9iR2 -> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'
  2 /

Session altered.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> ALTER SESSION SET TIME_ZONE = 'EST'   2 /

Session altered.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> DROP TABLE time_test
  2 /

Table dropped.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> CREATE TABLE time_test

  2  ( time_with_local_tz TIMESTAMP WITH LOCAL TIME ZONE
  3  , time_with_tz TIMESTAMP WITH TIME ZONE
  4  , time_without_tz DATE

  5 )
  6 /

Table created.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> INSERT INTO time_test
  2 VALUES (SYSTIMESTAMP, SYSTIMESTAMP, SYSDATE)   3 /

1 row created.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> SELECT * FROM time_test   2 /

TIME_WITH_LOCAL_TZ

---

TIME_WITH_TZ

---

TIME_WITHOUT_TZ

---

07-JUL-05 01.48.02.687403 PM
07-JUL-05 01.48.02.687403 PM -04:00
07-JUL-2005 13:48:02

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> ALTER SESSION SET TIME_ZONE = 'PST'   2 /

Session altered.

philip_at_ORA9iR2 ->
philip_at_ORA9iR2 -> SELECT * FROM time_test   2 /

TIME_WITH_LOCAL_TZ

---

TIME_WITH_TZ

---

TIME_WITHOUT_TZ

---

07-JUL-05 10.48.02.687403 AM
07-JUL-05 01.48.02.687403 PM -04:00
07-JUL-2005 13:48:02

Regards,

Phil Received on Thu Jul 07 2005 - 12:49:21 CDT