Home » Developer & Programmer » Forms » How to change English date in to Arabic date (Hijri) .
How to change English date in to Arabic date (Hijri) . [message #295303] Tue, 22 January 2008 01:35 Go to next message
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

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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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).
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 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
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..
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 Go to previous messageGo to next message
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.

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 Go to previous message
sasipalarivattom
Messages: 118
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:
  


Current Time: Fri Dec 02 21:06:09 CST 2016

Total time taken to generate the page: 0.14086 seconds