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_at_gmail.com> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 15 2007 - 14:47:48 CST
