Some1 help can't format mysql

[ninjatalon]

I've been trying to change format of mysql Date from yyyy/mm/dd to mm/dd/yyyy . I'm getting this error "Unable to convert MySQL date/time value to System.DateTime" . And i've tried using this

SELECT ID, 'First Name', 'Middle Name', 'Last Name', DATE_FORMAT('Date of Birth', '%m/%d/%Y') AS 'Date of Birth', Age, Gender, DATE_FORMAT('Current Enrollment Date', '%m/%d/%Y') AS 'Current Enrollment Date', 'Number of Household', Income, 'Income Frequency', 'No Income', 'Case Number', Category, DATE_FORMAT('Current 1531', '%m/%d/%Y') AS 'Current 1531', 'Full Name', 'No SSN' FROM children

but it doesn't want to change my format. Please someone help i had it working yesterday