Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Selecting TZD, TZR for timezones

Selecting TZD, TZR for timezones

From: Donahue, Adam <Adam.Donahue_at_kbcfp.com>
Date: Tue, 9 Jan 2007 17:12:51 -0500
Message-ID: <248A58C2AB63304C82F0706DE62FB345015AA3D4@nyc.kbcfp.com>


Folks,

Is it possible to select the textual mapping of the current time zone when the session (or database) time zone setting itself is numeric, e.g.,

                SQL> select systimestamp from dual;

                SYSTIMESTAMP         



---

                09-JAN-07 05.10.41.719683 PM -05:00                 SQL> select to_char( systimestamp, 'TZR' ) from dual;

		TO_CHAR(SYSTIMESTAMP,'TZR')
		--------------------------------
		-05:00

is not what we want. We want 'US/Eastern' returned from the second prompt - the problem, I'm suspecting, is that there's no way to map from
-05:00 back to US/Eastern reliably without other details, and Oracle
doesn't have though details. Whereas I can supply a date and the time zone in text which Oracle and convert to the right offset.

Is this possible?

Adam

--

This message may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived by any transmission to an unintended recipient. If you are not an intended recipient, please notify the sender and delete this message immediately. Any views expressed in this message are those of the sender, not those of any entity within the KBC Financial Products group of companies (together referred to as "KBC FP").

This message does not create any obligation, contractual or otherwise, on the part of KBC FP. It is not an offer (or solicitation of an offer) of, or a recommendation to buy or sell, any financial product. Any prices or other values included in this message are indicative only, and do not necessarily represent current market prices, prices at which KBC FP would enter into a transaction, or prices at which similar transactions may be carried on KBC FP's own books. The information contained in this message is provided "as is", without representations or warranties, express or implied, of any kind. Past performance is not indicative of future returns.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 09 2007 - 16:12:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US