ORACLE 6, new_time function error. Help?

From: Bruce Arbuckle <brucea_at_atlas.com>
Date: Wed, 5 Oct 1994 22:02:15 GMT
Message-ID: <1994Oct5.220215.15044_at_atlas.com>


I'm having a difficulty getting the function new_time to work for EET, MET, and WET time zones. I get "invalid time zone". I did a strings (unix command) on binaries in the ORACLE bin directory and find those time zones in with the EDT, EST,DST,AST,CST, etc, I can convert from GMT to any "US" time zone but not to the Europe time zones.
Can any one in Europe do the conversion to say PDT?

select to_char(new_time(to_date('01/01/94 00:00','dd/mm/yy hh24:mi'), 'GMT','EET'),'mm/dd/yy hh24:mi') from dual

 is what I use to test the problem. I'm using the function  in a reportwrite file in russia (ORACLE built here in the US and  shipped on the hard drive). All my testing was done using US timezones.  I ASS U ME D ORACLE would suppoprt the European time zones.  Does the ORACLE vrs in Europe support the "US" time zones?

 Thanks for you responses!

-- 
Bruce Arbuckle                                    EMAIL: brucea_at_adcmail.atlas.com
                                                  
Received on Wed Oct 05 1994 - 23:02:15 CET

Original text of this message