This discussion is archived
5 Replies Latest reply: Sep 24, 2012 3:56 AM by hitgon RSS

Persian Calander Support in Oracle11g

hitgon Expert
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Thanks a lots Osama_mustafa
  • 3. Re: Persian Calander Support in Oracle11g
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points