Loading ...
Sorry, an error occurred while loading the content.

SYSDATE returns in two different format in two different database even NLS_ parameters are same...

Expand Messages
  • Manoj Negi
    Hello Experts,   We are facing one strange issue with database migration (same release, same patch level). In Server # A (old server), database returns
    Message 1 of 3 , Jul 23 12:19 PM
    • 0 Attachment
      Hello Experts,
       
      We are facing one strange issue with database migration (same release, same patch level). In Server # A (old server), database returns SYSDATE in "MM/DD/YYYY HH:MI:SSXF" format whereas in Server # B (new server), database returns SYSDATE in "YYYY-MM-DD" format (before change)/ "DD-MON-RR" (after change).
       
      In initial analysis, it has been identified that INIT.ORA file parameters were different of Server # A and Server # B . So, database parameters (NLS_*) has been corrected and database were bounced back. After change, Server # B database started returning SYSDATE in "DD-MON-RR" format. Still, issue here is that it's not returning the SYSDATE is desired format i.e. Sever # A format....
       
      Question here is how to setup the value for SYSDATE to return the value in same format as Server # A. Can anyone point to some documentation or support case?
       
      Your quick response will be greatly appreciated. Thanks in advance for your reply!
       
      Manoj
       
      PS - All NLS_ parameters are same in Sever # A and Server # B.
    • margery brauner
      Check nls definition in the .profile of the server oracle account. ________________________________ From: Manoj Negi To:
      Message 2 of 3 , Jul 23 3:17 PM
      • 0 Attachment
        Check nls definition in the .profile of the server oracle account.

        From: Manoj Negi <negi2u@...>
        To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
        Sent: Tuesday, July 23, 2013 3:19 PM
        Subject: PeopleSoft DBA Forum SYSDATE returns in two different format in two different database even NLS_ parameters are same...
         
        Hello Experts,
         
        We are facing one strange issue with database migration (same release, same patch level). In Server # A (old server), database returns SYSDATE in "MM/DD/YYYY HH:MI:SSXF" format whereas in Server # B (new server), database returns SYSDATE in "YYYY-MM-DD" format (before change)/ "DD-MON-RR" (after change).
         
        In initial analysis, it has been identified that INIT.ORA file parameters were different of Server # A and Server # B . So, database parameters (NLS_*) has been corrected and database were bounced back. After change, Server # B database started returning SYSDATE in "DD-MON-RR" format. Still, issue here is that it's not returning the SYSDATE is desired format i.e. Sever # A format....
         
        Question here is how to setup the value for SYSDATE to return the value in same format as Server # A. Can anyone point to some documentation or support case?
         
        Your quick response will be greatly appreciated. Thanks in advance for your reply!
         
        Manoj
         
        PS - All NLS_ parameters are same in Sever # A and Server # B.
      • Manoj Negi
        Margery Brauner @ You re genius... :-) Thank you.. Thank you... Thank you... !!! ________________________________ From: margery brauner
        Message 3 of 3 , Jul 26 8:59 AM
        • 0 Attachment
          Margery Brauner @ You're genius... :-) Thank you.. Thank you... Thank you... !!!
          From: margery brauner <mbrauner2@...>
          To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
          Sent: Wednesday, 24 July 2013 3:47 AM
          Subject: Re: PeopleSoft DBA Forum SYSDATE returns in two different format in two different database even NLS_ parameters are same...
           
          Check nls definition in the .profile of the server oracle account.

          From: Manoj Negi <negi2u@...>
          To: "psftdba@yahoogroups.com" <psftdba@yahoogroups.com>
          Sent: Tuesday, July 23, 2013 3:19 PM
          Subject: PeopleSoft DBA Forum SYSDATE returns in two different format in two different database even NLS_ parameters are same...
           
          Hello Experts,
           
          We are facing one strange issue with database migration (same release, same patch level). In Server # A (old server), database returns SYSDATE in "MM/DD/YYYY HH:MI:SSXF" format whereas in Server # B (new server), database returns SYSDATE in "YYYY-MM-DD" format (before change)/ "DD-MON-RR" (after change).
           
          In initial analysis, it has been identified that INIT.ORA file parameters were different of Server # A and Server # B . So, database parameters (NLS_*) has been corrected and database were bounced back. After change, Server # B database started returning SYSDATE in "DD-MON-RR" format. Still, issue here is that it's not returning the SYSDATE is desired format i.e. Sever # A format....
           
          Question here is how to setup the value for SYSDATE to return the value in same format as Server # A. Can anyone point to some documentation or support case?
           
          Your quick response will be greatly appreciated. Thanks in advance for your reply!
           
          Manoj
           
          PS - All NLS_ parameters are same in Sever # A and Server # B.
        Your message has been successfully submitted and would be delivered to recipients shortly.