Re: Urgent: TZ problem

There's an article in here about getting the time zone, although I've not been able to get it to work:

http://www.oracle.com/oramag/oracle/00-nov/index.html?o60tom.html

"MS" <qcom_at_attbi.com> wrote in message news:a2b6d46b.0202201027.88b400a_at_posting.google.com...
> I don't think so.
> Normal convention is to set the date as per the local time zone - so
> the sysdate returns the date in local time zone. new_time is then used
> to get time for another time zone.
>
> -MS
>
>
> ramsunders_at_yahoo.com (R197509) wrote in message
 news:<1e562f83.0202190633.2517fc27_at_posting.google.com>...
> > Thanks MS. Re-starting the Listener process did the trick.
> > I checked out the new_time function as well. The external function
> > that we are calling is to get the local time zone. Then we are using
> > the time zone as a parameter to the new_time function to convert. Is
> > there a function in Oracle that gives the local time zone?
> >
> > Regards,
> > Ram.
> >
Received on Tue Feb 26 2002 - 20:14:53 CET