Operating System - HP-UX
1753620 Members
6317 Online
108797 Solutions
New Discussion юеВ

Re: oracle SYSDATE is different from HPUX date

 
Rick Garland
Honored Contributor

Re: oracle SYSDATE is different from HPUX date

Many thanks for feedback.

The connection can be local or remote, using the listener or not using the listener - achieving the same troubling results.

Fornunately this is a tst system but it is still aggrevating.

Have opened a tar with oracle - lets see what they say and I will post here.

Again, thanks!
Yogeeraj_1
Honored Contributor

Re: oracle SYSDATE is different from HPUX date

hi,

this problem is indeed intriguing me!

can you confirm that the following statement is also giving you this 15 mins off?

select sysdate from dual;

can you post a copy+paste of the entire output?

thanks
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Oliver Zell_1
Advisor

Re: oracle SYSDATE is different from HPUX date

Hi Rick Garland,

We were very pleased to see this problem has been tackled and although I understand that you are not obliged to answer, no misunderstanding here, I and my oracle colleague would be able to help a customer if you can reply with the oracle tar number that you opened in May. My email stuart.hill@sap.com. Thank you for your help.

Stuart Hill
Bernhard Baumann