get Date range when there are no date exists in table

This is my query it’s working fine.

But i want to get the blank record with the missing date, when there is no record exist for that date range, while fetching data from table.

SELECT * from tbl_social where `dCreatedDate` BETWEEN 
DATE_ADD('2015-07-06', INTERVAL 3 DAY) and DATE_SUB('2015-07-06', INTERVAL 3 DAY);

Thanking you.


Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.