Sorry for the delay, I was at the RMOUG the last couple of days. Not quite sure what you need, but you can probably accomplish what you want/need after looking at the Data datatypes section at http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14261/datatypes.htm. The section has some examples of some of the various functions, but you may need to jump over into the NLS documentation as well, to make sure your database is setup properly. Last time I got invloved in all this it took about 3 days of searching through countless Oracle docs before I got all the pieces in the right order. ----------------------------------------------------------------------------- Bill Ferguson U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750 Denver Federal Center Denver, Colorado 80225 Voice (303)236-8747 ext. 321 Fax (303)236-4208 ~ Think on a grand scale, start to implement on a small scale ~ UtahToad <mr.hicken@xxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 02/15/2007 12:48 PM Please respond to mr.hicken@xxxxxxxxx To oracle-l@xxxxxxxxxxxxx cc 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 -- //www.freelists.org/webpage/oracle-l