469,626 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

Get days

Is there anyway i get the total number of working days between two specified dates in TSQL?
Jul 11 '07 #1
2 1141
Vidhura
99
Is there anyway i get the total number of working days between two specified dates in TSQL?
Hope the following helps
select datediff(d,getdate(),'12/12/2007')
Jul 11 '07 #2
u can use the query like

Select Sum(WorkDays) TotWorkDays From WorkTable
Where WorkDate Between '01/01/2007' AND '06/30/2007'
Jul 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Johnson, Shaunn | last post: by
29 posts views Thread by james | last post: by
19 posts views Thread by Ricardo Perez Lopez | last post: by
8 posts views Thread by =?Utf-8?B?QWw=?= | last post: by
7 posts views Thread by Mike | last post: by
reply views Thread by geraldjr30 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.