> Hi, > > I was wondering how Date data type is dealt with in such databases > as PostgreSQL or mySQL? > > Databases usually have Date related operations such as equality, > less than, greater than, etc . But most databases have the Gregorian > Calendar and not Jalalian. > > Any solutions or hacks?
Jalali calender is not implemented in MySQL yet. But MySQL doesn't check the validity of Date entered. I mean you can enter any date having day part from 1 to 31. So Jalali Date can be saved in Date data type of MySQL. Also operations such as equality or .. works fine with it. The only problem is the Add_Date, Sub_Date and functions like that which doesn't work for Persian Date. A Multi-Calender system for MySQL is going to be developed in near future (probably by me) so if you need the full functionality, you should wait till then. Regards, -- __ \ /_\\_-//_ Mohsen A. Momeni < __\ _ /_ www.momeni.us.tc _______________________________________________ PersianComputing mailing list PersianComputing@lists.sharif.edu http://lists.sharif.edu/mailman/listinfo/persiancomputing