Home » RDBMS Server » Enterprise Manager » Creating New Calendar at oracle 9i
Creating New Calendar at oracle 9i [message #317210] Wed, 30 April 2008 00:55 Go to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
Is there anyone can lead me to creating new Calendar to the oracle 9i. I know that the oracle supported 7 kinds of calendar right now but I need to use the other one.
Re: Creating New Calendar at oracle 9i [message #317225 is a reply to message #317210] Wed, 30 April 2008 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you talking about Calendar in Oracle Collaboration Suite or calendar in RDBMS?

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #317386 is a reply to message #317225] Wed, 30 April 2008 22:56 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
RDBMS
Re: Creating New Calendar at oracle 9i [message #317399 is a reply to message #317386] Thu, 01 May 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing to do they are internal, hard coded and you can't add yours.

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #317917 is a reply to message #317399] Sun, 04 May 2008 23:18 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
Isn't it possible to set it at the deviation date?
Re: Creating New Calendar at oracle 9i [message #317930 is a reply to message #317917] Mon, 05 May 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what you meant with this.
Explain your question and precise your business need.

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #318100 is a reply to message #317930] Mon, 05 May 2008 10:36 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
I have some problem with the special calendar which is known for oracle. Some days at the calendar when convert from gregorian to my calendar will be increase or decrease (1 day ) for example 13870112 convert to 13870111(It is a leap year)
or some days will e increase for example 13861222 convert to 13861223.
At first I thought because of this problem I should define the new calendar but I think I can modify the existing calendar on the oracle.is n't it?
in order to have a correct date I think I should change some things at oracle but I do not know what should I do.
I use oracle form 6i and my data base is oracle 9i.
Oracle form 6i installed on my laptop and I connect to the oracle data base throught the network on the server side.
Re: Creating New Calendar at oracle 9i [message #318105 is a reply to message #318100] Mon, 05 May 2008 11:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot change Oracle, you have to change the procedures you have to convert from your calendar to Gregorian one. I think you have a bug in your procedures.

If you explain what is your calendar maybe I can help you more.

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #318152 is a reply to message #318105] Mon, 05 May 2008 23:00 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
It is "Persian". Can I modify any .nlt file at oracle?
Re: Creating New Calendar at oracle 9i [message #318156 is a reply to message #318105] Mon, 05 May 2008 23:04 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
And I do not use any procedure, by using nls_calendar=Persian at registry, oracle convert the date from gregorian to Persian calendar ownself.
Re: Creating New Calendar at oracle 9i [message #318184 is a reply to message #318156] Tue, 06 May 2008 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tell me what are the dates that are a problem and what you did to see this.
I will verify them with my own program maybe there is an error in Oracle calendar, did you search on Metalink?

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #318254 is a reply to message #318184] Tue, 06 May 2008 04:33 Go to previous messageGo to next message
mmrz
Messages: 29
Registered: August 2007
Junior Member
There is a field with date data type, I enter the forllowing dates and I can see the following results after pressing the tab button:
for example:

(This problem happens from tenth till last day of last month of each year)
13861217--------> 13861218
13861220--------> 13861221

(This problem is for the first day of first month of each year)
13870101--------> #########
13820101--------> #########
13650101--------> #########

(This problem is related to the leap year)
13870415-------->13870414(1387 is a leap year)
13870225-------->13870224(1387 is a leap year)
Re: Creating New Calendar at oracle 9i [message #318274 is a reply to message #318254] Tue, 06 May 2008 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give me the dates you expect in both calendars and the dates you have.

Regards
Michel
Re: Creating New Calendar at oracle 9i [message #318459 is a reply to message #318274] Tue, 06 May 2008 22:48 Go to previous message
mmrz
Messages: 29
Registered: August 2007
Junior Member
Persian date = yyyy/mm/dd
Gregorian date = mm/dd/yyyy

13861217 = 03072008
13861220 = 03102008

13870101 = 03202008
13820101 = 03212003
13650101 = 03211986

13840415 = 07062005
13870225 = 05142008
Previous Topic: OEM error VBO-1508
Next Topic: Showing the second canvas after the first one
Goto Forum:
  


Current Time: Fri Mar 29 03:37:58 CDT 2024