The columns ACT_MAX_DT and Acct_Act_DT are probably of character data types. In general, the best practice is to use DATETIME or another date/time data type when you want to store data/time. Assuming the columns are character data type, you can use replace to convert one to be like the other. For example, if you wanted ot use "/"
CREATE VIEW FINANCE_USER_TBLS.ddc582_OCAM_FINAL AS(
REPLACE(B.Acct_Act_DT,'-','/') as ,Acct_Act_DT
CASE WHEN A.ACT_MAX_DT= B.Acct_Act_DT THEN 'MAX' ELSE 'NOT' END UPLOAD_DATE
FROM FINANCE_USER_TBLS.ddc582_OCAM_MAX A, FINANCE_USER_TBLS.ddc582_OCAM_UPLOAD B
WHERE A.Acct_Uniq_Cust_No = B.Acct_Uniq_Cust_No )