Convert using CONVERT function ...

function | Convert add convert to query ...
CONVERT (varchar (10), field name, conversion format)

Like what:
Select User_id,convert (varchar), date,11) as date from Tb_user

Conversion format:
0 or month DD yyyy hh:miampm
1 mm/dd/yy
2 YY.MM.DD
3 Dd/mm/yy
4 dd.mm.yy
5 Dd-mm-yy
6 DD Month YY
7 Month Dd,yy
8 HH:MI:SS
9 or 109 month DD yyyy Hh:mi:ss:mmmAMPM
Ten Mm-dd-yy
One YY/MM/DD
Yymmdd
Mm/dd/yyyy
102 YYYY.MM.DD
Dd/mm/yyyy
Dd.mm.yyyy
Dd-mm-yyyy
YYYY DD Month
Month DD,YYYY
108 Hh:mi:ss
Mm-dd-yyyy
Yyyy/mm/dd
112 YYYYMMDD