Thread: UTC.GET_LOCAL_DATE SQL Performance
View Single Post
  #5 (permalink)  
Old June 5th, 2008, 23:26
sknmail@rediffmail.com sknmail@rediffmail.com is offline
Member
  
Join Date: May 2007
Location: India
Posts: 69
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
sknmail@rediffmail.com is on a distinguished road
Send a message via Yahoo to sknmail@rediffmail.com
Re: UTC.GET_LOCAL_DATE SQL Performance
Hi Chris,

We recently migrated our Devl environment from 4.5 to 5.5 CU#4 RU#1.

We could find when we run the the sql statement on migrated 5.5 Database
select UTC.GET_LOCAL_DATE (SYSDATE, NULL) from dual; throws an exception "ORA-20000: Undefined time zone for location".

However this same used to run on 4.5 Database. Now we have a bunch of reports which uses this function and all those reports are now throwing this exception. We do have raised a SR with Oracle on this, however still research is going on.

I will keep you update on this on receipt of a workaround.

Regards,
Suresh
Reply With Quote
The Following User Says Thank You to sknmail@rediffmail.com For This Useful Post:
chrisplough (June 6th, 2008)