i want to store values, which are related to a month in a year. The exact day is not interesting. My first idee was to use the date format as providesd by mysql (YYYY-MM-DD), an fill the DD part with a dummy value. But if someone else will mantain this later, surely the question will come "why did you use always a dummy for DD". Therefore i dont want to store data which has no sense.
I thought there would be a way to define a column with a format like "YYYY-MM"
Originally Posted by r937
and what's so wrong with a DATE column with values '1998-12-00'?
I dont want to store datn which has no information (-00). If there's no direct way provided by the DB, i'll have to find on by myself (or with your help: two clumns).
Further or later someone (or me) will think "what the hell does -00 meen?"