Date Conversion

SELECT     member_name , CONVERT(CHAR(10), END_DATE, 101) AS DATE
FROM         dbo.GROUP_PATIENT
WHERE     (GROUP_ID = 13)

SELECT     *
FROM         dbo.GROUP_PATIENT
WHERE     (GROUP_ID = 13)