ORACLE 6, new_time function error. Help?
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.comReceived on Wed Oct 05 1994 - 23:02:15 CET