RE: Urgent Date Problem

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 08 May 2001 14:22:46 -0700
Message-ID: <F001.002FD213.20010508140242@fatcity.com>

It seems that the environment variable TZ was not set correctly in the Oracle account before starting the database.

-----Original Message-----
Sent: Tuesday, May 08, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L

Hi Everybody

I need advise for one of mine problem. I am trying to access database from ODBC test in Windows to Server on UNIX and when doing

select sysdate from dual;

then are getting let say 12:00pm

and when trying to run the same query on the server by telnet to server, it is working fine and giving current time of 11:00am. The problem is been seen from the Daylight Saving time Change.

Due to this problem, mine application is also rporting the time difference of 1 hour in mine one of the Date column which is populated by trigger containg same Sysdate value assigne to the vaiable and then using that variable to insert into the tables. The problem is reported only after the Daylight saving Change

Thanks in Advance for everybody comments and help

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Navtej B
INET: navtej_b_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------