For an example:
SELECT CURDATE (), MONTH ("DateFieldName") FROM "TableName"
Shouldn't CAST() be included?