Advice on handling date preferences

[eluser]Aken[/eluser]
DATETIME does come with built-in MySQL functionality, yes. They both have their pros and cons. DATETIME is not UTC-specific, so you'll need to keep that in mind if you plan to change dates/times into a user's time zone.

That SO question has good info, give it a read.