Getting duplicate column ERROR while trying to insert same column with two different datatypes using SELECT INTO clause in PostgreSql

Question

I need to insert createdate column twice with two different datatypes one with the datatype defined in the table itself and another in char datatype. I can insert it by changing the alias name of createdate column but can't insert with same alias name which i need. so help me out to get correct way of doing it.

My query:

    SELECT DISTINCT TE.id, T.debatchqueuelink, TE.transactionlink, 
                    EC.errorclassification, TE.errorvalue, 
                    EC.errorparameter, TE.classificationlink, TE.description, 
                    TE.createdate AS createdate, TO_CHAR(TE.createdate,  'MM/dd/yyyy') AS createdate, 
                    TE.status, TE.rebutt, TE.rebuttedstatus, BQ.appbatchnumber, 
                    BQ.scanbatchnumber, BQ.clientlink, BQ.locationlink, T.patientid, 
                    (DEUD.firstname|| ' ' ||DEUD.lastname) AS deusername, DEUD.email AS deuseremail, 
                    (QCUD.firstname|| ' ' ||QCUD.lastname) AS qcusername, TE.inactive, 
                    TE.decomment  
                 INTO table373 
                 FROM qctransactionerror TE
                INNER JOIN errorclassification EC ON EC.id = TE.classificationlink
                INNER JOIN qctransaction T ON T.id = TE.transactionlink
                INNER JOIN batchqueue BQ ON T.debatchqueuelink = BQ.id
                INNER JOIN batchqueue QCBQ ON T.qcbatchqueuelink = QCBQ.id
                INNER JOIN userdetail QCUD ON QCBQ.assignedto = QCUD.id
                INNER JOIN userdetail DEUD ON BQ.assignedto = DEUD.id 
                WHERE TE.inactive='t' 
                  AND TE.status IN ('ERROR','QCCORRECTED')
                LIMIT 0  

The actual error message I am getting is:

Duplicate column:column "createdate" specified more than once