SELECT CONVERT(varchar, CONVERT(datetime, Birthdate), 100)
100 format does the trick
Got it myself
Thanks