• # To get the number of days in a certain month in a specified range

I need to get the number of days in a certain month in a specified range

I have a start date & end date
For eg , start date = 1/8/2016
end date = 31/12/2016.I need to get the no . of days allocated in september.

How to find that?
• Hi,

We can simply get those days range. You have not specified you have this requirements in .net or Sql
Let me post you for both.

.NET
------

We can subtract the days from and to and multiple with the days.
Suppose
FromDate = 1-9-2016
ToDate = 30-9-2016

So you can perform,
`DateTime FromDate;DateTime ToDate;return (ToDate- FromDate)`

SQL
------

In Sql it will be much simpler because we have predefined function for those.

`declare @FromDate datetimedeclare @ToDate datetimeset @FromDate = '01/09/2016'set @ToDate = '30/09/2016'select DATEDIFF(d, @FromDate , @ToDate )Value= 30`

Kindly let us know is this what you are expecting. Or something else

Thanks,
Mani

• Hai Anu,
There is a inbuilt function called as DATEDIFF in Sql Server which can be used to get the difference in between dates by passing the 'from date' and 'To date'as the input parameters.
`Select DATEDIFF (d, @fromDt , @toDt))`
We can also get the difference between dates in Weeks, Months, years etc.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

• hi Anu,
yes we can simply find between two months values in day formation. with the use of date function months between. I will explain 1 example hope you can understand easily.

example: find the day value between Issue_date and submission_day from issue_detail table

select book_code,issue_date,submission_date,
months_between(submission_date,issue_date)*31 "total days"
from issue_detail;

run this query in your pc and see the result you can understand cleary.