Re: Jalali Calendar in MySQL (was Re: PersianComputing Digest, Vol 21, Issue 5)
On Sat, 19 Feb 2005, Masoud Sharbiani wrote: And if you are using the mysql frontend (i.e. Command line?) http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html has the full set of functions for handling date. Most of the functions there are calendar agnostic, like DATE_ADD, et al. BTW, if you really need Iranian calendar in there, I suggest writing it as an stored procedure. Then you don't need administrator priviledges to install the procedure, any user can do that. cheers, Masoud --behdad http://behdad.org/ ___ PersianComputing mailing list PersianComputing@lists.sharif.edu http://lists.sharif.edu/mailman/listinfo/persiancomputing
Re: Jalali Calendar in MySQL (was Re: PersianComputing Digest, Vol 21, Issue 5)
On Wed, 16 Feb 2005, Masoud Sharbiani wrote: I think it kinda does. After all, if they have some sql functions to deal with the dates stored on the tables and databases, if some guy (read government office or whatever) wants to store persian dates in the db, they have to have two conversion functions from Jalali to Gregorian(sp?) and reverse. Then you have these conversion functions in your programming language and convert as part or preparing your SQL query. --behdad http://behdad.org/ ___ PersianComputing mailing list PersianComputing@lists.sharif.edu http://lists.sharif.edu/mailman/listinfo/persiancomputing
Re: PersianComputing Digest, Vol 21, Issue 5
Hello, About jalali or Iranian calender, i think fighting about what the name should be is of no use and will make a lot of problems for us. I know everything about them. that Jalali calender is based on calculation and iranian calender has a astoronomical basis. But all these arguments will lead to our failiur for having a standard calender in iran. I have added Jalali (Persian , Iranian , ) calender to MySQL as a set of functions having J at the beginnig of each of them. But I think developers of mysql has read all these arguments in mailing lists and may decided to forget about the patch as I have got no aswer till now. I think we have one target and that is having jalali (or ...) calender in our databases NO MATTER WHAT THE NAME IS. ___ PersianComputing mailing list PersianComputing@lists.sharif.edu http://lists.sharif.edu/mailman/listinfo/persiancomputing
Re: PersianComputing Digest, Vol 21, Issue 5
Hi, On Wed, 16 Feb 2005, mohsen ali momeni wrote: Hello, About jalali or Iranian calender, i think fighting about what the name should be is of no use and will make a lot of problems for us. I know everything about them. that Jalali calender is based on calculation and iranian calender has a astoronomical basis. But all these arguments will lead to our failiur for having a standard calender in iran. No. Wrong. I have added Jalali (Persian , Iranian , ) calender to MySQL as a set of functions having J at the beginnig of each of them. But I think developers of mysql has read all these arguments in mailing lists and may decided to forget about the patch as I have got no aswer till now. No. They simply are not interested in your functions. I think we have one target and that is having jalali (or ...) calender in our databases NO MATTER WHAT THE NAME IS. Again no. Calendars does not belong to databases. --behdad http://behdad.org/ ___ PersianComputing mailing list PersianComputing@lists.sharif.edu http://lists.sharif.edu/mailman/listinfo/persiancomputing