sql server - How can I get the data with select query with not writing all columns extenally and date formating is possible -

i have stored procedure fetches data registered users want date of birth change in format mm/dd/yyyy. can convert function how fetch record select query? need write vales separately or can fetch simple select query , @ same time change date format well?

create procedure getall begin     select * tbl_regis end  create procedure getall begin    select convert(varchar(20), dob, 103) dob tbl_regissadhak end 

you should specify columns want , have apply conversion on every column want converted.