RE: Getting the Current Timezone

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 15 Feb 2007 15:08:54 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B4A@EXCNYSM0A1AJ.nysemail.nyenet>

Toad,

This is a great question. I rolled my own and would love to see a smarter answer.

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of UtahToad Sent: Thursday, February 15, 2007 2:48 PM To: oracle-l_at_freelists.org
Subject: Getting the Current Timezone

In all the research and testing I have done, I cannot find a function that
will return the timezone for what you need. You can get the time in a different timezone and some things like that, but I cannot find a way to have the system give you the MDT or MST back to you. I find people wanting
this and the answer was that they would have to write something themselves..

Any ideas?

--

2/15/2007 --
UtahToad
Before a diamond shows its brilliancy and prismatic colors it has to stand a good deal of cutting and smoothing.
-- Author Unknown

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 15 2007 - 14:08:54 CST