SELECT *,DATEDIFF(NOW(),`YourDateField`) AS `DiffDate` FROM `table` WHERE `x` = 'y'

this will return an additional column for every row containing the date difference between the current date and the date stored in the database.