ayha1999
asked on
Time manipulation using SQL SP or C#
How can write add hours with a date for the folloiwng case?
Supose today(30/04/2011) we are working from 7am to 3pm and tomorrow is a holiday and after tomorrow(2/05/2011) work starts at 7 and finish 5). if we get a repair work today and need 7 hours to finsih it, we have to add this 7 hours with the current date and time (let's say 10 am now) and it should display the finishing date and time. The remaining working hours need to added with the next work starting hours, if the next day is holiday (eg. Sunday), then the remaining hours should be added with Monday's starting time.
How can I achive it using sql stored procedure or c#?
Please give a sample or good links.
ayha
Supose today(30/04/2011) we are working from 7am to 3pm and tomorrow is a holiday and after tomorrow(2/05/2011) work starts at 7 and finish 5). if we get a repair work today and need 7 hours to finsih it, we have to add this 7 hours with the current date and time (let's say 10 am now) and it should display the finishing date and time. The remaining working hours need to added with the next work starting hours, if the next day is holiday (eg. Sunday), then the remaining hours should be added with Monday's starting time.
How can I achive it using sql stored procedure or c#?
Please give a sample or good links.
ayha
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
thanks
ayha