how to find missing dates in month in SQL

Aug 20 2018 5:17 AM

Hi all,

I have one column and that column contain 2 years dates . this column contain like every day data.

column example data: 2018-07-23 05:00:00.000

2018-07-24 05:00:00.000

2018-07-26 05:00:00.000

2018-07-28 05:00:00.000

2017-07-23 05:00:00.000

2017-07-24 05:00:00.000

2017-07-26 05:00:00.000

2017-07-28 05:00:00.000

etc for 3rd year also

like wise 3 years data. now i wanted to get missing dates from above data.

example:in 2018 i have 23 ,24 26,28 days data but

my query should return these 25 and 28 two dates like wise missing all 3 years months dates

could any one help on this?

Answers (1)

Export data Sql to Excel