How to get 7 days before today date in mysql?

Thank you for replay me sir, I will check!

Check here for date formats :

http://www.mysqltutorial.org/mysql-date_format/

Than you for replay me sir!

But It's not working for me and need output have to be like above.

Hello Abhilash Jayakumar thanks for writing below links i hope helpful for you..:)

http://stackoverflow.com/questions/17717515/how-to-query-for-todays-date-and-7-days-before-data

http://stackoverflow.com/questions/2833241/how-to-get-the-30-days-before-date-from-todays-date

Special Thanks C-sharpcorner