I currently run a website that has different content each day. The content is saved in the database and the primary key is the date. I get the system date from the server and query for todays conent with that date variable. Currently the date field is a primary key and I chose to keep the field int(6) so the format is mmddyy. So I have one question:
1)Should I change my date field to be of date type instead of int? The reason I chose int is because I thought it would make the database faster.
I know some may say this won't make a difference, but this is for a class and I'm wanting the best choice for this date primary key type. I will be presentint this site to my teachers and don't want them to question why I chose int type instead of date if it doesn't make since.