|
Why not use: "if timestamp1 + 8 hours > timestamp2"? Loocks clear to me. rob@xxxxxxxxx wrote:
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
