Re: AW: SQL - Calculate the number of hours between 2 timestamps

I agree, it sucks.  However, when you think about what you would do with a 
calculating the difference between two timestamps, doesn't the decimal 
answer work "good enough"?  The OP wanted to know if the duration was 
greater than 8 hours.  We posted something like select ts1-ts2 from ... 
and got a number.  And if that number was greater than 80000 then it was 
greater than 8 hours.

If is not "good enough" and you have a business reason, then see if you 
can find a standard, preferably ISO, that says otherwise.  IBM won't 
change timestampdiff because someone is probably using it and is counting 
on it's anomalies.  But if you have a strong enough business case, and 
submit a DCR then perhaps they'll come out with timestampdiffiso.  Don't 
know what the odds of them ever creating one that says timestampdiffMS for 
MicroSoft.  Legal reasons, animosity, and possible confusion with 
milliseconds might intervene.

Rob Berendt