Select Code to Download

SELECT * from `your_table_name` WHERE DAY(time) = DAY(NOW())

SELECT * from `your_table_name` WHERE 
  YEAR(time) = YEAR(NOW()),
  DAYOFYEAR(time) = DAYOFYEAR(NOW())