select CONVERT(varchar(30),date_fieldname,120) as date_fieldname from ...