10 TIPs - To Become a Good Developer/Programmer
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
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?
Reply
Answers (
1
)
Export data Sql to Excel
Effect of space on SQL Queries