TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
venkat
NA
138
51.7k
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