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]