I have an application where each user is assigned an expiration date. If the expiration date (a MySQL datetime type) is empty (0000-00-00 00:00:00) then the user does not expire. If there is a date present, I want the user to expire on and after that date.
MySQL uses one date/time format, and PHP uses another. What's the best way to handle dates?