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 |
|
jkimpson
Starting Member
4 Posts |
 Posted - 2007-12-14 : 09:08:18
|
| When I get the DateDiff of 2 sets of dates one set is positive, while the other is negative. Theoretically that's correct but once I get the 2 sets of numbers I need to add them to get a total of how long a task took. How would I change my DateDiff so that it returns a postive number on both sets of dates so I can add the 2 returned numbers and it doesn't throw my calculations off?Thx 4 your help,Joyce |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-12-14 : 09:11:24
|
| You should be a familiar with all of the different functions sql server provides. (There's really not that many, for better or worse!) ABS() is one of them. Read about it in Books On Line.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
jkimpson
Starting Member
4 Posts |
Posted - 2007-12-14 : 09:13:41
|
Thx Jeff!I appreciate you quick response on guiding me in the right direction.Joyce:o) Smilequote:
Originally posted by jsmith8858
You should be a familiar with all of the different functions sql server provides. (There's really not that many, for better or worse!) ABS() is one of them. Read about it in Books On Line.- Jeffhttp://weblogs.sqlteam.com/JeffS
|
|
|
|
|
|
|
Change DateDiff to Positive Numbers