Home » SQL & PL/SQL » SQL & PL/SQL » Convert from Georgian Date(English Date) To Arabic Hijri Date
Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436063] Mon, 21 December 2009 04:54 Go to next message
obasad
Messages: 10
Registered: March 2006
Location: Riyadh
Junior Member


Hello to all,


Kindly i want command in PLSQL that Convert sysdate From Georgian Date (English Date) To Arabic Hijri Date (Umm Al Qura).

Best Regards
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436065 is a reply to message #436063] Mon, 21 December 2009 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select to_char(sysdate,'DD Month YYYY','NLS_CALENDAR=''Arabic Hijrah''') from dual;
TO_CHAR(SYSDATE,'DDMO
---------------------
04 ¿¿¿¿          1431

1 row selected.

SQL> select to_char(sysdate,'DD Month YYYY','NLS_CALENDAR=''English Hijrah''') from dual;
TO_CHAR(SYSDATE,'DDMONTHY
-------------------------
04 Muharram          1431

1 row selected.

Of course I can't see arabic characters, so I posted the english version.

Regards
Michel
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436066 is a reply to message #436063] Mon, 21 December 2009 05:05 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.orafaq.com/forum/t/150700/0/


http://forums.oracle.com/forums/thread.jspa?threadID=180322


http://ksadba.wordpress.com/page/2/

Always search before posting.


sriram Smile
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436068 is a reply to message #436066] Mon, 21 December 2009 05:08 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
From dba-village.com

Sriam Smile
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436069 is a reply to message #436063] Mon, 21 December 2009 05:09 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The actual date is the same everywhere.

What you're actually looking for is how to set the NLS Parameter and use To_Char to display the date in Hiriji.

Try this:
select to_char(sysdate,'Day Month yyyy','NLS_DATE_LANGUAGE = ARABIC') from dual;
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436071 is a reply to message #436065] Mon, 21 December 2009 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Valid calendar values: http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm#sthref311

Regards
Michel
Re: Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436072 is a reply to message #436071] Mon, 21 December 2009 05:14 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I stand (or rather sit) corrected.
Previous Topic: single row with multiple column into single column - urgent
Next Topic: DB Link
Goto Forum:
  


Current Time: Fri Dec 09 06:14:54 CST 2016

Total time taken to generate the page: 0.11571 seconds