Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail From: "Phil" Newsgroups: comp.databases.oracle.server Subject: Re: Timezone Conversion Date: 7 Jul 2005 10:49:21 -0700 Organization: http://groups.google.com Lines: 79 Message-ID: <1120758561.356455.229550@g14g2000cwa.googlegroups.com> References: <1120750399.092967.243940@g44g2000cwa.googlegroups.com> <1120758150.078104.113800@g44g2000cwa.googlegroups.com> NNTP-Posting-Host: 192.44.136.103 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1120758566 21567 127.0.0.1 (7 Jul 2005 17:49:26 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 7 Jul 2005 17:49:26 +0000 (UTC) In-Reply-To: <1120758150.078104.113800@g44g2000cwa.googlegroups.com> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g14g2000cwa.googlegroups.com; posting-host=192.44.136.103; posting-account=m0hfZAwAAABmK50IdlOJiuwHe1VsU6RB Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246786 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@ORA9iR2 -> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' 2 / Session altered. philip@ORA9iR2 -> philip@ORA9iR2 -> ALTER SESSION SET TIME_ZONE = 'EST' 2 / Session altered. philip@ORA9iR2 -> philip@ORA9iR2 -> DROP TABLE time_test 2 / Table dropped. philip@ORA9iR2 -> philip@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@ORA9iR2 -> philip@ORA9iR2 -> INSERT INTO time_test 2 VALUES (SYSTIMESTAMP, SYSTIMESTAMP, SYSDATE) 3 / 1 row created. philip@ORA9iR2 -> philip@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@ORA9iR2 -> philip@ORA9iR2 -> ALTER SESSION SET TIME_ZONE = 'PST' 2 / Session altered. philip@ORA9iR2 -> philip@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