I have a monthly fee collecting table. I need to store year and month only for that purpose. For example just like to store, John has done the payment for 2010 July. I thought of using a DATE field for this. I can store the year and month with valid values and denote date with 0. (2011-07-00)
I need to know whether there is a way to insert the year and month values only without setting the date value to 0 manually. Further when retrieving the values there are functions to get YEAR() and MONTH(), MONTHNAME() separately. Is there a way to retrieve these two only together like it can be retrieved the year and week together by YEARWEEK().
Any clarifications highly appreciated.