Setting Date column to the current date
Just use Now() as you would for a DateTime
MyDateColumn = NOW(),WHERE based on a date
The same as for a DateTime column:
WHERE MyDateColumn < DATE_SUB(now(), INTERVAL 180 DAY)Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.