If you need to delete rows or reset data in columns older than X days using MySQL, then there is an easy way to do it: Deleting Rows from your table X days old: DELETE FROM mytable WHERE recorededDate < DATE_SUB(NOW(), INTERVAL 25 DAY); Resetting Columns from your table X days old: UPDATE mytable SET […] ↓ Read the rest of this entry…
Proper date time format (ISO) for insertion into a MySQL field from classic ASP code
Update parts of a text string within a field for all records of the table
MySQL time and date functions are well documented (http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html), but the applications for specific needs are not. I would like to share a tidbit about comparing two database date entries, or one entry to the current time and then comparing the difference. The application is for an auction website, where I am comparing the current […] ↓ Read the rest of this entry…