Average in mysql with date

Question

I am working on Averaging several rows of data and I have been busting my butt figuring it out and I "think" Im down to the last error.

ERROR 1584 (42000): Incorrect parameters in the call to stored function 'cast'

I get this when I run this

select avg(volume) from _AAPL WHERE date between cast('2014-02-03' as date) and cast ('2014-05-05'     as DATE); 

_AAPL is my table, date is my column "date" the dates are already in the database under "date"

I cannot get rid of this error, any ideas?

Answer 1

You should not have any space after "CAST" :

cast('2014-05-05' as DATE)

instead of

cast ('2014-05-05'     as DATE)

By the way i'm not sure it's mandatory to cast dates when they are already formatted like 'yyyy-mm-dd' : i would just write

`column` BETWEEN '2014-02-03' AND '2014-05-05'