3 Replies Latest reply: Jun 15, 2012 9:33 AM by a.aurel RSS

    Need to change systimestamp from +01:00 to +08:00

    Nagaraju P
      Hi Experts,

      I need to change systimestamp from +01:00 to +08:00.

      SYSTIMESTAMP
      ---------------------------------------------------------------------------
      14-JUN-12 03.29.47.657901 PM +01:00 =====> I need to change it as +08:00

      Could anybody please help me how can i change it?

      I added TZ=SGT in my listener.ora file and bounced the listener. Even though systimestamp is still showing --> +01:00

      Please help me on this..