Below are some methods of comparing dates in MYSQL.
Finding rows entered in the last 6 months with MYSQL.
SELECT *
FROM table_name
WHERE post_date > DATE_SUB(GETDATE(), INTERVAL 6 MONTH)
Finding the number of days between two dates
SELECT DATEDIFF(end_date ,start_date)
FROM table_name;
Finding the midpoint or average between to dates.
SELECT (start_date+INTERVAL DATEDIFF(end_date ,start_date)/2 DAY)
FROM table_name;