OraFAQ Forum: Forms » How to change English date in to Arabic date (Hijri) .

Home » Developer & Programmer » Forms » How to change English date in to Arabic date (Hijri) .

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

How to change English date in to Arabic date (Hijri) . [message #295303]

Tue, 22 January 2008 01:35

dillango
Messages: 145
Registered: January 2008

Senior Member

Hi,

When the user enters English date, it should display the Arabic date (Hijri) automatically viz. How to do this?

Please it is urgent for me.

Thanks in Advance
ILANGO

Report message to a moderator

Re: How to change English date in to Arabic date (Hijri) . [message #295309 is a reply to message #295303]

Tue, 22 January 2008 01:53

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Dates are stored in a format not recognizable to us, humans. In order to display a date as desired, we use the TO_CHAR function.

Date item can have its own format mask; to change it, use the SET_ITEM_PROPERTY built-in such as this example:

set_item_property('date_item', format_mask, 'mon dd yyyy');

You'd, of course, use your date format (I don't know how "Hijri" dates look like).

Report message to a moderator

Re: How to change English date in to Arabic date (Hijri) . [message #295311 is a reply to message #295303]

Tue, 22 January 2008 01:57

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Hi dear,

I dont know about it but I shall give you a suggestion.

search in this forum with your requirement.
I do a search and found that there were same questions posted earlier.
1 is here

This question is not answered. but u can ask author of this question how he solved it.

Good Luck..

If you get the solution, Do post it..

Regards
Sasi..

Report message to a moderator

Re: How to change English date in to Arabic date (Hijri) . [message #295314 is a reply to message #295303]

Tue, 22 January 2008 02:02

dillango
Messages: 145
Registered: January 2008

Senior Member

Hi,

I know these formats by using to_char.. What I want is, for example, When we enter English date as 22nd Jan,2008, it should display the Hijri date ie. 13/01/1429.

I think it is clear now.

Report message to a moderator

Re: How to change English date in to Arabic date (Hijri) . [message #295321 is a reply to message #295314]

Tue, 22 January 2008 02:14

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Please check this link....

[Updated on: Tue, 22 January 2008 03:14]

Report message to a moderator

Previous Topic:	dynamic query
Next Topic:	Difference between dates in years, months, days

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 02:00:29 CST 2024