OraFAQ Forum: General » can we customize the calender in Oracle?

Home » Other » General » can we customize the calender in Oracle?

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

can we customize the calender in Oracle? [message #103826]

Mon, 29 March 2004 21:56

Sushil Chandra
Messages: 3
Registered: March 2004

Junior Member

hi, can i customize the�the calender in oracle.

like can i store 32-jan-2004 or 33-feb-2004 in oracle.

thanks in advance

Report message to a moderator

Re: can we customize the calendar in Oracle? [message #103829 is a reply to message #103826]

Tue, 30 March 2004 06:25

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

quote from Sushil Chandra:
----------------------------------------------------------------------

hi, can i customize the the calender in oracle. 

like can i store 32-jan-2004 or 33-feb-2004 in oracle. 

thanks in advance

----------------------------------------------------------------------

SQL> SELECT TO_DATE('32-JAN-2004','DD-MON-YYYY') FROM DUAL;
SELECT TO_DATE('32-JAN-2004','DD-MON-YYYY') FROM DUAL
               *
ERROR at line 1:
ORA-01847: day of month must be between 1 and last day of month
 
 
SQL>

No.

Why would you want to?

Report message to a moderator

Re: can we customize the calendar in Oracle? [message #103830 is a reply to message #103829]

Tue, 30 March 2004 22:04

Sushil Chandra
Messages: 3
Registered: March 2004

Junior Member

in indian (hindi) calender there may be 32 days in particular month. and i have to store it. is it possible in any ways?

Report message to a moderator

Re: can we customize the calendar in Oracle? [message #104066 is a reply to message #103830]

Sat, 17 July 2004 20:14

Meenakshi
Messages: 28
Registered: December 2001

Junior Member

select '32'||'-'||to_char(to_date('jan-2004','mon-yyyy'),'mon-yyyy')from dual

Report message to a moderator

Previous Topic:	Database Web Service Call-ins.
Next Topic:	Stop run away Oracle Service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:11:01 CST 2024