Best way to store Hijri dates in mysql ?

Question

I am developing a web application using CakePHP and mysql and all the dates in the system use the Islamic/Hijri calendar(http://en.wikipedia.org/wiki/Islamic_calendar) . I was wondering what is the best way to store Hijri dates in mysql?

Note: I already use Keith Wood's jQuery DatePicker(http://keith-wood.name/datepick.html).

Answer 1

it is possible to translate between Hijri and Gregorian on the fly (see http://yse-uk.com/?page_id=13) so you could simply store your dates as Gregorian and convert them before displaying.

Answer 2

Actually, you don't have to use any external library . Use the Keith Wood Calendar plugin to convert the Hijri date to timestamp or to Gregorian . Then save it in a normal datetime field in mysql.