how to change date format to 'mm/dd/yyyy' from 'yyyy-mm-dd'

[Tanaji]

I am trying

dimension: tdate {
type: date
sql: DATE_FORMAT(${TABLE}.“TDATE”,’%m/%d/%Y’) ;;
}

but not getting output