All Forums Teradata Applications
TRMyoung 1 post Joined 09/12
10 Sep 2012
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_KY)  as CAST((CAST(DATE AS FORMAT 'MMMDD')) AS CHAR(5)) from testble

 

thanks

 

You must sign in to leave a comment.