3 Replies Latest reply: Apr 16, 2012 2:10 AM by Hemant K Chitale RSS

    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