Re: Urgent: TZ problem
From: MS <qcom_at_attbi.com>
Date: 20 Feb 2002 10:27:12 -0800
Message-ID: <a2b6d46b.0202201027.88b400a_at_posting.google.com>
Date: 20 Feb 2002 10:27:12 -0800
Message-ID: <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 Wed Feb 20 2002 - 19:27:12 CET