Well, thats actually what i am going to do. A date column won't take anything but a valid date (sort of - feb. 30 is "valid"). But i still need to know whether the day of month is meaningful or not, for various search / display purposes. My users will raise a major stink if i tell them that the date is the first, but it actually isn't, so the display functionality for the system will check the date validity flag, and if invalid, only display the month and year.
Not sure what kind of feedback you are looking for here, but it seems to me the only other solution would be to actually roll your own date format using separate columns for year, month, and day-of-month. Then you could leave day of month NULL, where appropriate.
-bluejack
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
