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 |
|
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 -> 07pmresult: 40h finiched at Friday 01pmregards 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
count hours with datetime