RE: [PHP-DB] Dates
| From: | John Holmes | Date: | Fri, 27 Sep 2002 21:51:24 +0000 |
| Subject: | RE: [PHP-DB] Dates | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22062@lists.php.net to get a copy of this message | ||
> 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...