Quick question here. Though its probably not a huge deal, it might make a performance difference.
I am working on a database that will store different sporting events (baseball, football, basketball, etc). All of these events will have times for the event. Typically the date and time values will not be viewed together (different table cells for example).
The way I see it, if I have a DATETIME field then I would require a bit more php processing to seperate the two for display purposes. But using seperate DATE and TIME fields would make my queries a bit longer and possibly(?) take up more storage space.
I know, I'm probably analyzing this too much. Any input would be great!