Fixing the "date"

[anamada]

I TRIED THIS CODE AND THE RESULT IS EXACTLY WHAT I WANTED TO HAPPEN. BUT HOW WILL I APPLY THIS ON MY DATABASE? THIS IS ONLY SELECT. AM I GOING TO DO SOMETHING UPDATE? CREATE ?

SELECT TOP 17 RIGHT ('000000'
+ CAST (CER_CERT_ISSUE_DATE AS VARCHAR (6)), 6) CER_CERT_ISSUE_DATE
  FROM [sto_database].[dbo].[Certmast]
  order by CER_CERT_ISSUE_DATE asc
  


SELECT TOP 17 RIGHT (REPLICATE('0', 6)
+ CAST (CER_CERT_ISSUE_DATE AS VARCHAR (6)), 6) CER_CERT_ISSUE_DATE
  FROM [sto_database].[dbo].[Certmast]
  order by CER_CERT_ISSUE_DATE asc