• Oops should have been

    Select Convert(char(10),GetDate(),101)