DB 2 DATEタイプ表示時に、00:00:00、消す方法、VARCHAR()関数を使う

DROP VIEW DMS.V_AQ_INSURANCECLAIMS;
CREATE VIEW DMS.V_AQ_INSURANCECLAIMS AS
SELECT * FROM (SELECT 
T1.FRAMENO AS    ,
T1.LICENSENO AS    ,
T10.CARMODELNAME AS   ,
T7.CUSTOMERNAME AS     ,
T7.MOBILEPHONE AS     ,
T1.REPAIRNO AS     ,
--    
VARCHAR(T11.DELIVEREDDATE) AS     ,
T3.COMMONNAME AS     ,
VARCHAR(T1.FIXEDDATE) AS     ,
T6.FULLNAME AS     ,
T9.COMMONNAME AS     , 
CASE WHEN T1.ISPROXY = 'Y' THEN ' ' WHEN T1.ISPROXY = 'N' THEN ' ' END AS      ,
T1.WORKFEE AS       ,
T1.PARTFEE AS       ,
T1.OTHERFEE AS       ,
T1.TOTALFEE AS       ,
VARCHAR(T1.SUBMITDATE) AS     ,
T1.NOTE AS   
             
             FROM RT_INSURANCECLAIMS T1
             LEFT JOIN CM_COMMONCODE T2 ON T1.STATUS = T2.COMMONCODE AND T2.CODETYPE = 'CR29'
             LEFT JOIN CM_COMMONCODE T3 ON T1.COMPANYCODE = T3.COMMONCODE AND T3.CODETYPE = 'CC12'        
             LEFT JOIN CM_STAFF T6 ON T1.CLAIMSID = T6.STAFFPKID 
             LEFT JOIN UM_CUSTOMER T7 ON T1.CUSTOMERNO = T7.CUSTOMERCODE 
             LEFT JOIN VM_CARINFO T8 ON T1.FRAMENO = T8.FRAMENO 
             LEFT JOIN VM_CARMODEL T10 ON T8.CARMODELPKID = T10.CARMODELPKID 
             LEFT JOIN CM_COMMONCODE T9 ON T1.ACCIDENTTYPE = T9.COMMONCODE AND T9.CODETYPE = 'CR42' 
             LEFT JOIN RT_REPAIRPROCESS T11 ON T1.REPAIRNO = T11.REPAIRNO
         
         ) T