Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Set deadlines by adding business days or hours Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2007 5:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:47 AM
Points: 977, Visits: 326
Comments posted to this topic are about the item Set deadlines by adding business days or hours


Post #421520
Posted Tuesday, July 2, 2013 3:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 4:20 AM
Points: 18, Visits: 21
When I use minutes and seconds in the start date, it does not add the minutes.

DECLARE @return_value int,
@dEndDate datetime

SELECT @dEndDate = N'2013-06-29 21:39:07'

EXEC @return_value = [dbo].[bcssp_AddBusinessHours]
@dBegDate = N'2013-06-29 21:39:07',
@iHours = 10,
@cBusBeg = N'08:00:00',
@cBusEnd = N'18:00:00',
@dEndDate = @dEndDate OUTPUT

SELECT @dEndDate as N'@dEndDate'

SELECT 'Return Value' = @return_value

Gives me "2013-07-02 08:00:00.000" as the result...


Sorry, did not see that my startdate was at saturday, calculation is correct!
Post #1469353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse