OraFAQ Forum: Enterprise Manager » Creating New Calendar at oracle 9i

Home » RDBMS Server » Enterprise Manager » Creating New Calendar at oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating New Calendar at oracle 9i [message #317210]

Wed, 30 April 2008 00:55

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.

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #317225 is a reply to message #317210]

Wed, 30 April 2008 01:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you talking about Calendar in Oracle Collaboration Suite or calendar in RDBMS?

Regards
Michel

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #317386 is a reply to message #317225]

Wed, 30 April 2008 22:56

mmrz
Messages: 29
Registered: August 2007

Junior Member

RDBMS

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #317399 is a reply to message #317386]

Thu, 01 May 2008 01:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing to do they are internal, hard coded and you can't add yours.

Regards
Michel

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #317917 is a reply to message #317399]

Sun, 04 May 2008 23:18

mmrz
Messages: 29
Registered: August 2007

Junior Member

Isn't it possible to set it at the deviation date?

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #317930 is a reply to message #317917]

Mon, 05 May 2008 00:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know what you meant with this.
Explain your question and precise your business need.

Regards
Michel

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318100 is a reply to message #317930]

Mon, 05 May 2008 10:36

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.

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318105 is a reply to message #318100]

Mon, 05 May 2008 11:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318152 is a reply to message #318105]

Mon, 05 May 2008 23:00

mmrz
Messages: 29
Registered: August 2007

Junior Member

It is "Persian". Can I modify any .nlt file at oracle?

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318156 is a reply to message #318105]

Mon, 05 May 2008 23:04

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.

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318184 is a reply to message #318156]

Tue, 06 May 2008 01:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318254 is a reply to message #318184]

Tue, 06 May 2008 04:33

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)

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318274 is a reply to message #318254]

Tue, 06 May 2008 05:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Give me the dates you expect in both calendars and the dates you have.

Regards
Michel

Report message to a moderator

Re: Creating New Calendar at oracle 9i [message #318459 is a reply to message #318274]

Tue, 06 May 2008 22:48

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

Report message to a moderator

Previous Topic:	OEM error VBO-1508
Next Topic:	Showing the second canvas after the first one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:27:01 CST 2024