> I am doing a database of things that have dates, some I know the month >and year of, some I only know the year. I suppose I could do a field for >the year, and one for month, and then allow the month to be NULL. But is >there a date type that allows years and / or months???
If that's all you have is a year, or a year-month, then you don't have a date. You have and year and you have a month. Use an integer or text column to store it, and process it with PHP. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php