HPE Community
Operating System - HP-UX
1757744 Members
1916 Online
108863 Solutions
New Discussion

Re: Database time is 1 hour behind

 
Daniel Moloisane
New Member

‎08-23-2007 09:03 PM

‎08-23-2007 09:03 PM

Database time is 1 hour behind

Hello,

My database is one hr behind the system time

/etc/TIMEZONE reads:
TZ=SAST-2
export TZ

if u run the following as oracle on SQL:
SQL> select systime from dual;

DBTIME
- - - -
+03:00

How do you solve this problem?

0 Kudos
Reply
1 REPLY 1
Dennis Handly
Acclaimed Contributor

‎08-23-2007 09:31 PM

‎08-23-2007 09:31 PM

Re: Database time is 1 hour behind

What is the value of TZ before you execute the SQL command? Does it match TIMEZONE above?
$ env | grep TZ
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.