How to get 7 days before today date in mysql?

Question

Hi sir How to get 7 days before today date in mysql using query? I want output like this:- 16/12/2016 Tuesday 17/12/2016 Wednesday 18/12/2016 Thursday

Mani Kandan · Answer

Thank you for replay me sir I will check!

ali tuncer · Answer

Check here for date formats : http://www.mysqltutorial.org/mysql-date_format/

Mani Kandan · Answer

Than you for replay me sir! But It's not working for me and need output have to be like above.

Krishna Rajput Singh · Answer

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