How to get the Datediff between two fields

[dougancil]

I'm trying to get the datediff (in minutes) between two fields in a database. These fields are going to be supplied by an end user so they can be any number or any day. The two fields are starttime and endtime and the table name is Exceptions. Can anyone offer a way to do this? I'm using SQL 2000.

Thank you,

Doug

[gpl]

Books online gives you the syntax
its along the lines of

Select 
DateDiff(mm, starttime, IsNull(endtime, starttime))
From Exceptions

[dougancil]

When I run that query I get a value of 0 in all fields. I know that this can't be right.

here's the query I have:

Select 
DateDiff(m, starttime, IsNull (endtime, starttime))
From Exceptions2
 

[dougancil]

I figured this out .... here is the syntax that I have:

SELECT datediff(minute, starttime, endtime)  as duration from Exceptions2
where exceptiondate between '5/1/2010' and '5/15/2010'
 

[gpl]

Doug
yup, you spotted the problem - mm means minute in time, but month in datediff and datepart

sorry for the bum steer
Graham