 Urgent -How to save not latin dates? [message #129395] |
Mon, 25 July 2005 01:16  |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Hi there,
Is there anybody knows how can I save not latin dates in Oracle? I mean for example: Jalali(shamsi) calender or Arabic Calender(Hijri) instead of using Julian Calendar.
Currently we do this by saving this dates in varchar type and another equivalent Latin datetime(e.g. 2 columns).We perform operations on Latin and then manipulate the varchar column and ofcourse application always will see this varchar column.
-Thanks alot
|
|
|
|
| Re: Urgent -How to save not latin dates? [message #129444 is a reply to message #129395] |
Mon, 25 July 2005 05:13  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
By default Oracle uses the Gregorian calendar system. However, the following systems are supported (as documented in the Oracle 10g Database Globalization Support Guide):
- Japanese Imperial
- ROC Official
- Thai Buddha
- Persian
- Arabic Hijrah
- English Hijrah
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
