Hi Tao - guess we could always just run both methods over a largish table and get stats out of the query analyser (like cpu usage, etc) ... In terms...
I am pretty sure that use of datediff won't work well with indexes, since it requires a calculation to be performed on every row that is being compared.