Select left(convert(varchar(10),f_xstime,120),7) f_xstime from xs_records group by left(convert(varchar(10),f_xstime,120),7) order by f_xstime desc

Select distinct left(convert(varchar(10),f_xstime,120),7) f_xstime from xs_records  order by f_xstime desc