3 Replies Latest reply on Apr 16, 2012 7:10 AM by Hemant K Chitale

    SYSTIMESTAMP from Client returns different time on HP-UX

    Sohil
      Dear Friends,

      We have 11g DB on HP-UX .

      Below are out puts

      On Server it self with sqlplus;
      SQL> select systimestamp from dual;

      SYSTIMESTAMP
      ---------------------------------------------------------------------------
      16-APR-12 11.55.24.370864 AM +05:30


      On Client machine through SQL Developer
      16-APR-12 02.28.37.450752000 AM -04:00

      Why this difference is coming?

      Canu help please