Convert Birthdate into Month(abreviated), Day, Year, Time

Transact-SQL
6

SELECT CONVERT(varchar, CONVERT(datetime, Birthdate), 100)

100 format does the trick

Got it myself

Thanks