it's definitely the specifying that the command is a stored procedure.

I've been having the exact same problem for a day and to no avail, but luckily found this thread and...

this should work,

select avg(cast(date_field as int)) from wherever

Thanks