How to – SQL Format Date and Format Datetime using T-SQL Convert Function

Very good article on Koydaz website – click here, on how to format SQL Date using T-SQL Convert Function