Category: SQL Server

07 Oct 2016 16:22

Joined:	07/10/2016
Level:	Bronze
Points:	5

Points:	2

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?

#768042

07 Oct 2016 17:25

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

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 datetime
declare @ToDate datetime

set @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

#768066

09 Oct 2016 16:59

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	3

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

#768073

10 Oct 2016 09:52

Joined:	28/09/2016
Level:	Bronze
Points:	24

Points:	4

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.
hope this help you

thank you

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

About dotnetspider.com

Quick Links

General

Services