This discussion is archived
3 Replies Latest reply: Jan 24, 2009 8:58 AM by 553533 RSS

persian date in oracle form6i

576153 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    salam,

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

    movafagh bashid

    Iman