Re: Urgent: TZ problem
From: MS <qcom_at_attbi.com>
Date: 13 Feb 2002 10:27:59 -0800
Message-ID: <a2b6d46b.0202131027.42b3d08a_at_posting.google.com>
Date: 13 Feb 2002 10:27:59 -0800
Message-ID: <a2b6d46b.0202131027.42b3d08a_at_posting.google.com>
- Check out if TZ was set when starting the listener process.
- you might want to check out new_time sql function instead of going
for external c function.
-MS
ramsunders_at_yahoo.com (R197509) wrote in message news:<1e562f83.0202112143.50a8a97a_at_posting.google.com>...
> Hi,
> We have a UNIX box that has the Time zone set as IST. However, for
> the Oracle database instance, we need to have the time zone set to
> MST. The problem we are facing is as follows:
> We have a stored procedure which calls another funtion to get the
> Local Time Zone. This function is an External C function which gets
> the time zone for the UNIX box by calling the 'C' tzset function to
> get the time zone.
> Now we tried executing this C function as a stand-alone program at
> the UNIX prompt and the time zone returned by this function depends on
> the TZ variable set, i.e. if TZ for the UNIX session was set to IST,
> output was IST and if it was MST, the output was MST.
> Now, we set the TZ variable to MST and then logged onto a sqlplus
> session. However, when the stored procedure was executed, the time
> zone returned continued to remain IST.
> At this point, we thought that this might be because the stored
> procedure executes in the Oracle UNIX Id environment (not sure if that
> is true) and hence tried setting the TZ variable to MST for the Oracle
> ID before starting up the database. The result though was still IST.
> Any idea on what is amiss here. How do we go about this?
>
> Any help is appreciated.
> Thanks.
> Regards,
> Ram.