venkat

venkat

  • 1.9k
  • 138
  • 41.8k

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)