|
DATE or DATETIME if you need to store the time as well. Allows for all kinds of good date operations. For example, that two week thing:
SELECT * FROM table_name WHERE date_added >= date_sub(now(), interval 2 week);
__________________
xMarkPro -- Ultimate Blog Network Management
Streamline your marketing operations. Centralize management of domains, pages, Wordpress blogs, sponsors, link codes, media items, sales and traffic statistics, plus more!
|