SELECT eventID, CONVERT(eventDate, CHAR(10)) AS Date FROM space_firsts;

Here is the exact same output using the CONVERT instead of the CAST

Examples Of The CAST and CONVERT Functions