I'm in the habit of handling date and time manipulations at the code level. I normally get the timestamp I need using time() and then store this value in the database. It works but I wonder whether there is a better way.
Of course I'm aware that MySQL can handle dates and times but I've just never taken the time to understand how to the get the most out of this functionality. My code worked perfectly well and I always had more interesting things to tackle.
This recent article from
phpbuilder though has kick-started my interest in what MySQL can do with a date. It seems like a nice overview and who knows, maybe the next application I put together will take less time() to create. [Thank you very much . . . I'm here 'til Thursday]