Renaming Name field to return date value

Teradata Applications

Renaming Name field to return date value

I have a query and want to return the date as the field name. What do I need to do to turn the date value as a field name?

select Suppress_Cd, supp_desc,

count(distinct STHD_KYas CAST((CAST(DATE AS FORMAT 'MMMDD')) AS CHAR(5)) from testble

thanks