Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2013-06-26 : 09:09:45
|
| Hi All,Monday - Friday 9AM - 04:30 PM ESTBased on above formula I have to calculate the diffrence in Minutes between two datesPlease suggest |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 10:07:41
|
you need to pass them as startdate,enddate and starttime and endtime values then you will be able to do something like belowSELECT dbo.BusinessHours(@startdate,@enddate,@starttime,@endtime) AS TimeDiff BusinessHours UDF can be found herehttp://visakhm.blogspot.in/2010/03/calculating-business-hours.htmlAlso you need to remove the /60.0 part inside UDF if you want result in minutes------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
DateDiff