select convert(varchar(12), mydate, 3) from table