SQL Query Help

[rsunra]

G'day

I have a field Stored as a Varchar on the format 00:00:00 and I want to get a 15 min average group day the day

I have the follow code:

What I think I need to do is first convert the Varchar to HH:mm:ss using the convert(char(9),[call_duration],14) as Duration

How can I set the Average call duration using a Case Statement?

ie AVG (Duration(CASE WHEN DATEPART(hour,[call_start]) = 0 and DATEPART(mi,[call_start]) BETWEEN 00 and 15 ) AS '00:00-00:15',

 

[AtomicWedgie]

CASE
WHEN DATEPART(hour,[call_start]) = 0 and DATEPART(mi,[call_start]) BETWEEN 00 and 15 ) THEN '00:00-00:15'
END