Back in 2005 a user requested on the MySQL bug tracker that the TIME/DATE based data types store microseconds. I personally don’t think this is an unreasonable request and judging by the many posts to the bug report by users between then and now this is something quite a few people would like to see. [...] [...more]
Learn how to program OOP in PHP and convert MySQL timestamp to the “Ago” format. Using a PHP class. Get the Zip Download Package Here: www.developphp.com [...more]
Or how can I subtract two timestamps in PHP? [...more]
I created a table with a timestamp column that’s defaulted to current_timestamp through the wizard; however I forgot to make this auto-updated on update. how do I modify this through sql now? searched alter table commands but can’t get it to work. can someone help? [...more]
I’m using mysql for a project (not my choice) and I need to create a column that just does a timestamp on create, not on every update. Simply using timestamp as the column type doesn’t work as it changes on update. I want to clarify that this is mysql version 3 [...more]
