Convert function for Select only date from datebase

SELECT CONVERT(VARCHAR(10), Dob, 103) as dob from Application

select current date

Select CONVERT(VARCHAR(10), getdate(), 110)

 show data in gridview in   13 August 2012 Formate

                             <td>
                                <%# Eval("DOB", "{0:D}")%>
                            </td>