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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-10-01 : 05:08:47
|
| Hi,Using the folowing start and end dates, how can I write a sql query to calculate the number of working hours (i.e. 9-5) but EXcluding weekends.startdate: 01/06/2004 08:30:22enddate: 24/06/2004 12:29:34Currently I have a function which works out the number of days excluding the weekends.Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 05:16:56
|
| duplicate postshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40735 |
 |
|
|
|
|
|
date