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 |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2011-02-23 : 09:18:34
|
| Help please?How can I add 30 seconds to a time value, basically I just want to add the value of 30 seconds to the select statement.SELECT CONVERT(CHAR(8), DATEADD(SECOND, (AVG(CallCompletedAfter - CallAnsweredAfter)), 0), 8) AS [Average Duration]FROM CallSummaryI thought it would go here DATEADD(SECOND,30..or possible replace the 0 above??Help appreciated.Thanks |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-02-23 : 10:40:31
|
| DATEADD(SECOND, (AVG(CallCompletedAfter - CallAnsweredAfter))+30, 0)JimEveryday I learn something that somebody else already knew |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2011-02-23 : 10:51:58
|
| Cheers Jim that did the trick...everyday I'm learning a little more...Thanks again. |
|
|
|
|
|
|
Adding 30 seconds to a time SP