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)
 count hours with datetime

Author  Topic 

sami022
Starting Member

11 Posts

Posted - 2012-12-26 : 20:55:00
how to count 40h between two datetime for exp. :
count 40h launched at Monday between 09am -> 01pm and 02pm -> 07pm
result: 40h finiched at Friday 01pm

regards Sami,

hi every body!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-26 : 23:27:14
sorry not clear. do you mean adding 40 h from a date? then use dateadd

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -