SELECT convert(nvarchar,CREDATE,104) AS DATE FROM TBLARTICLE

SELECT convert(nvarchar,CREDATE,105) AS DATE FROM TBLARTICLE

SELECT convert(nvarchar,CREDATE,106) AS DATE FROM TBLARTICLE

SELECT convert(nvarchar,CREDATE,107) AS DATE FROM TBLARTICLE