OraFAQ Forum: SQL & PL/SQL » Convert from Georgian Date(English Date) To Arabic Hijri Date

Home » SQL & PL/SQL » SQL & PL/SQL » Convert from Georgian Date(English Date) To Arabic Hijri Date

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

Convert from Georgian Date(English Date) To Arabic Hijri Date [message #436063]

Mon, 21 December 2009 04:54

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

Report message to a moderator

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

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

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

Report message to a moderator

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

ramoradba
Messages: 2457
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

Report message to a moderator

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

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

From dba-village.com

Sriam Smile

Report message to a moderator

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

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;

Report message to a moderator

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

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

Senior Member
Account Moderator

Valid calendar values: http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm#sthref311

Regards
Michel

Report message to a moderator

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

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I stand (or rather sit) corrected.

Report message to a moderator

Previous Topic:	single row with multiple column into single column - urgent
Next Topic:	DB Link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 14 08:52:18 CDT 2026