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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DateDiff

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2013-06-26 : 09:09:45
Hi All,

Monday - Friday 9AM - 04:30 PM EST

Based on above formula I have to calculate the diffrence in Minutes between two dates

Please 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 below



SELECT dbo.BusinessHours(@startdate,@enddate,@starttime,@endtime) AS TimeDiff


BusinessHours UDF can be found here

http://visakhm.blogspot.in/2010/03/calculating-business-hours.html

Also you need to remove the /60.0 part inside UDF if you want result in minutes

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -