## After creating the Table use these queries  ###
USE my_db; # use your database name
SELECT * FROM dt_table WHERE DATE=CURDATE(); # 1 , todays record 
SELECT * FROM dt_table WHERE DATE=CURDATE()- INTERVAL 1 DAY; # 2 ,  yeserday record 
SELECT * FROM dt_table WHERE DATE=CURDATE()+ INTERVAL 1 DAY; # 3, tomorrow's record 
# Yesterday , today , tomorrow records  
SELECT * FROM dt_table WHERE DATE in(CURDATE()- INTERVAL 1 DAY,CURDATE(),CURDATE() + INTERVAL 1 DAY); # 4  
SELECT * FROM dt_table WHERE DATE BETWEEN CURDATE()- INTERVAL 2 DAY  AND CURDATE(); # 5 , last two days records  
SELECT * FROM dt_table WHERE DATE BETWEEN CURDATE() AND CURDATE()+ INTERVAL 3 DAY; # 6, next three days records
SELECT * FROM dt_table WHERE DATE BETWEEN CURDATE() -INTERVAL 10 DAY AND CURDATE()- INTERVAL 5 DAY; # 7, previous 10 to 5 days 
SELECT * FROM dt_table WHERE DATE BETWEEN CURDATE() + INTERVAL 5 DAY AND CURDATE() + INTERVAL 10 DAY; # 8, Next 5 days to next 10 days 
SELECT * FROM dt_table WHERE MONTH(DATE) = MONTH(CURDATE()); # 9 , Current month includes all years 
SELECT * FROM dt_table WHERE MONTH(DATE) = MONTH(CURDATE()) AND YEAR(DATE) = YEAR(CURDATE()) ; # 10 , Current month of current year  
SELECT * FROM dt_table WHERE MONTH(DATE) = MONTH(CURDATE())-1 AND YEAR(DATE) = YEAR(CURDATE()); # 11,Previous  month of current year 
SELECT * FROM dt_table WHERE MONTH(DATE) = MONTH(CURDATE())+1 AND YEAR(DATE) = YEAR(CURDATE()); # 12 Next  month current year  
# 13 Previous month, current month and next month 
SELECT * FROM dt_table WHERE MONTH(DATE) IN( MONTH(CURDATE())-1, MONTH(CURDATE()), MONTH(CURDATE())+1);
SELECT * FROM dt_table WHERE DATE BETWEEN DATE_FORMAT(CURDATE(),'%Y-%m-01') AND CURDATE(); # 14 current month till today
SELECT * FROM dt_table WHERE YEAR(DATE) =YEAR(CURDATE()); # 15 Present year records 
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =WEEKOFYEAR(CURDATE()); # 16 Present week
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =WEEKOFYEAR(CURDATE())-1; # 17 Previous  week
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =WEEKOFYEAR(CURDATE()) +1; # 18 Next  week
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =1 AND YEAR(DATE) = YEAR(CURDATE()); # 19 ,First week of current year
# 20 current week all working days ( Monday to Friday ) 
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =WEEKOFYEAR(CURDATE()) AND WEEKDAY(date) BETWEEN 0 AND 5  AND YEAR(DATE) = YEAR(CURDATE()) ; #20
# 21 current week all working days till today  ( Monday to today  ) 
SELECT * FROM dt_table WHERE WEEKOFYEAR(DATE) =WEEKOFYEAR(CURDATE()) AND WEEKDAY(date) BETWEEN 0 AND WEEKDAY(curdate())  AND YEAR(DATE) = YEAR(CURDATE()); # 21