Determining DATETIME durations

[Den2Fly]

Hello buddies, How can I determine the time distance between two DATETIME values and compare the result with various time units like seconds, minutes, days, ... ? I guess it has a standard method that I prefer, but anyway my target SQL is MS SQL Server 2000. Thank you so much for your note --- "Art happens when you least expect it."

[David Salter]

You need to use the DATEDIFF function. Full details are in the BOL.

---

store your internet favourites online - www.my-faves.co.uk

[Den2Fly]

Thank you, Thank you, Thank you and once more, Thank you ;-) --- "Art happens when you least expect it."