Re: Getting the Current Timezone
- From: "John Darrah" <darrah.john@xxxxxxxxx>
- To: mr.hicken@xxxxxxxxx
- Date: Thu, 15 Feb 2007 13:47:48 -0700
Can you refine your question? Do you want a function that returns the
timezone set at the database or are you looking for a function that returns
the timezone for a given location? For the first, you can issue "select
DBTIMEZONE from dual;". The second would be difficult to create. What
would you use as your key? If you use capital city, there are 13 states
that would potentially return the wrong answer to the user. Probably the
only semi reliable thing would be long / lat coordinates but even that would
return the wrong answer if some municipality decides they want to be on EST
instead of CST after you created your location to timezone map.
On 2/15/07, UtahToad <mr.hicken@xxxxxxxxx> wrote:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
