I want to work out how many hours there is between a start time and a finish time.

I want to work out how many hours there is between a start time and a finish
time.
For example
Start Time: 10:00 am
Finish Time: 11:00 am
Is 1 hour?
How can this be achieved using T-SQL or a stored proc?
Wayne Taylor
www.kryptos.co.uk/blog
On Thu, 14 Oct 2004 14:34:36 +0100, Wayne Taylor wrote:

>I want to work out how many hours there is between a start time and a finish
>time.
Hi Wayne,
SELECT DATEDIFF(hour, @.Datetime1, @.Datetime2)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)