3 Replies Latest reply: Jan 24, 2009 10:58 AM by 553533 RSS

    persian date in oracle form6i

    576153
      I inserted the NLS_CALENDAR= PERSIAN in registry.There is a Problem with the date field for the first day of first month of each year.for example when I enter 1386/01/01 or 1345/01/01 or 1376/01/01,... and then press the TAB button it shows me like #########. the date field datatype is date and the length is 10.
      What is the solution?
        • 1. Re: persian date in oracle form6i
          328847
          Salam ghorban,

          man fekr mikonam ke soal-e-tun be in ghesmat rabti nadareh, in bakhsh, bakhshe OCS ast, valli dar har hall, say konid NLS_LANG dar Database ra taghir bedahid, ja dar Form yek triger dorost konid.

          be omideh movafaghiyat
          Amir
          • 2. Re: persian date in oracle form6i
            454753
            Hi.

            Salam

            Moteasefaneh 6i in moshkelo dareh hata akharin noskhe on ro ham ke nasb kardim bazham moshkelo dareh.

            Darzemn az tarikh 1386/12/10 between 1386/12/29 agar kar bar meghdar dehi konad 1 roz tarikh jolo miravad deghat konid.

            Select to_char(to_date('21-MAR-07'),'yy/mm/dd','nls_calendar=''persian''') from dual;

            Shayad komaketon koneh.

            Best regards.
            • 3. Re: persian date in oracle form6i
              553533
              salam,

              man ham ba hamin moshkel barkhord kardam va daram roosh kar mikonam. agar rahe hallesho peyda kardin lotfan post bezarid.

              movafagh bashid

              Iman