Have you tried
SELECT FORMAT (GETDATE(), 'MM/dd/yyyy ') AS Date
You do realise that formatting only applies to dates in strings - dates which are prepared for presentation to the user in some form. No formatting you apply to a DATE, DATETIME or DATETIME2 column will be retained as dates are stored as a number of ticks since a specific point in time, not as a "date" value.