select dbtimezone from dual; On Thu, 2007-02-15 at 12:48 -0700, UtahToad 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? > -- //www.freelists.org/webpage/oracle-l