5 Replies Latest reply: Sep 24, 2012 5:56 AM by hitgon RSS

    Persian Calander Support in Oracle11g

    hitgon
      Hi Gurus

      We have setup the Oracle11g R2 in RHEL 64bit Platform.
      How can we configure/create the new calendar in Oracle

      We want to configure the Persian Calander in Oracle11g.

      How to find the Persian's 1 day of the month?

      I have go through the below link
      http://www.orafaq.com/forum/t/119356/2/
      http://www.irantour.org/Iran/iranianmonths.html

      Appreciate for help in advance

      Regards
      Hitgon
        • 1. Re: Persian Calander Support in Oracle11g
          Osama_Mustafa
          read
          FAQ on the Arabic Hijrah ( Hijri ) Calendar [ID 121061.1]
          Dates & Calendars - Frequently Asked Questions [ID 227334.1]
          • 2. Re: Persian Calander Support in Oracle11g
            hitgon
            Thanks a lots Osama_mustafa
            • 3. Re: Persian Calander Support in Oracle11g
              Helios-GunesEROL
              Hi;

              Please also review:
              Does Oracle support the Farsi / Persian language (used in Iran, Afghanistan, Tajikistan, ....)? [ID 274108.1]



              PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding

              Regard
              Helios
              • 4. Re: Persian Calander Support in Oracle11g
                hitgon
                Thanks for great help............


                Jalali Calendar?????
                We want to use Iranian Calendar (Jalali Calendar)?

                How to configure and use the Iranian Calendar (Jalali Calendar) in Oracle?
                http://www.iranchamber.com/calendar/converter/iranian_calendar_converter.php

                Please help us.
                • 5. Re: Persian Calander Support in Oracle11g
                  hitgon
                  please verify my solution

                  I got the solution using below way...........
                  nls_calendar='PERSIAN

                  create or replace view vw_first_day_of_month_persian
                  as
                  select 1 as gregorian_month,to_char(to_date('01/01/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 2 as gregorian_month,to_char(to_date('01/02/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 3 as gregorian_month,to_char(to_date('01/03/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 4 as gregorian_month,to_char(to_date('01/04/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 5 as gregorian_month,to_char(to_date('01/05/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 6 as gregorian_month,to_char(to_date('01/06/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 7 as gregorian_month,to_char(to_date('01/07/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 8 as gregorian_month,to_char(to_date('01/08/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 9 as gregorian_month,to_char(to_date('01/09/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 10 as gregorian_month,to_char(to_date('01/10/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 11 as gregorian_month,to_char(to_date('01/11/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual
                  union
                  select 12 as gregorian_month,to_char(to_date('01/12/2012','DD/MM/YYYY','nls_calendar = ''gregorian'''),'day dd month yyyy','nls_calendar=''PERSIAN''') persian_date from dual;

                  set pagesize 10000
                  select * from vw_first_day_of_month_persian;



                  GREGORIAN_MONTH PERSIAN_DATE
                  --------------- -----------------------------
                  1 sunday 11 Dey 1390
                  2 wednesday 12 Bahman 1390
                  3 thursday 11 Esfand 1390
                  4 sunday 13 Farvardin 1391
                  5 tuesday 12 Ordibehesht 1391
                  6 friday 12 Khordad 1391
                  7 sunday 11 Tir 1391
                  8 wednesday 11 Mordad 1391
                  9 saturday 11 Shahrivar 1391
                  10 monday 10 Mehr 1391
                  11 thursday 11 Aban 1391
                  12 saturday 11 Azar 1391


                  Regards
                  Hitgon

                  Edited by: hitgon on Sep 24, 2012 4:26 PM