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(SELECT A.Acct_Uniq_Cust_No,A.ACT_MAX_DT,REPLACE(B.Acct_Act_DT,'-','/') as ,Acct_Act_DTCASE WHEN A.ACT_MAX_DT= B.Acct_Act_DT THEN 'MAX' ELSE 'NOT' END UPLOAD_DATEFROM FINANCE_USER_TBLS.ddc582_OCAM_MAX A, FINANCE_USER_TBLS.ddc582_OCAM_UPLOAD BWHERE A.Acct_Uniq_Cust_No = B.Acct_Uniq_Cust_No )