|
|
| Re: arabic date to english date [message #381880 is a reply to message #381873] |
Tue, 20 January 2009 03:44   |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
1) An Oracle date is not Gregorian or Arabic or in any other format, an Oracle date is an internal representation in an internal format.
2) You can convert varchar2 (a formatted string) into a date with the to_date function.
3) You can convert a date into an varchar2 with the to_char function.
4) the to_date and the to_char functions can have a nls_calendar parameter.
An example for some to_chars :
select
to_char(sysdate,'day dd month yyyy',
'nls_calendar=''Arabic Hijrah'''),
to_char(sysdate,'day dd month yyyy',
'nls_calendar=''English Hijrah'''),
to_char(sysdate,'day dd month yyyy',
'nls_calendar=''gregorian''')
from dual;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
