For an example:
SELECT CURDATE (), MONTH ('2010-10-11') FROM "Table"
(note double, single quotes)
Also:
Here is another list of stored procedures/functions including CAST() and IFNULL():
[1]
Here is a free download using various built-in functions: [2]