Xref: alice comp.databases.oracle.misc:56662 comp.databases.oracle.server:90211 comp.databases.oracle.tools:42252 Path: alice!news-feed.fnsi.net!newsxfer.visi.net!165.176.32.251.MISMATCH!dit4.state.va.us!not-for-mail From: "Alan Moorman" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools References: <38E9F6BC.31470781@bmc.com> <38EA0EB6.43E76828@bmc.com> Subject: Re: Help... How to determine GMT time in Oracle? Lines: 27 X-Newsreader: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: Date: Tue, 4 Apr 2000 12:33:04 -0400 X-Trace: dit4.state.va.us 954865869 198.204.97.21 (Tue, 04 Apr 2000 12:31:09 EDT) NNTP-Posting-Date: Tue, 04 Apr 2000 12:31:09 EDT Organization: Dept of Information Technology Well, I didn't fully read your post. I searched MetaLink and it seems that this is a problem which Oracle's addressing in 8i. There were some references by people who've written custom code (Java or external procs) to accomplish this. The disturbing thing about 8i is that it looks like the functionality is "hidden" and unpublished. The suggestion was to call OTS and ask about how to set up TIME_WITH_TIMEZONE and TIMESTAMP_WITH_TIMEZONE functionality. Hope you're on 8i!! Alan Eleanor Sokol wrote in message <38EA0EB6.43E76828@bmc.com>... >What do you do for the time zones which are not supported (i.e. Moscow)? >Unfortunately new_time does not support all the time zones of the world it >seems. > >Elly > > >Alan Moorman wrote: > >> select to_char(new_time(sysdate,'edt','gmt'),'mm-dd-rrrr hh24:mi:ss') from >> dual; >