Tools › Date format matrix
SQL Server date format codes cheat sheet
CAST cannot take a style. CONVERT can. FORMAT is pretty and slow in a WHERE. Pick the pair.
Related: CONVERT styles, CAST and CONVERT.
Learn it on a real ticket
Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.
Clock in free