title: How to convert the date that have been retrieve from DB to only display d/mm/yyyy?
body: <p>I have this <code>21/10/1999</code> value manually inserted into the SQL database and when I retrieve it like this:</p>
  
  <pre><code>txtDOB.Text = readPatient["pDOB"].ToString();
  </code></pre>
  
  <p>It displays everything along with the time <code>12:00:00 AM</code>. My data type for my date column is <code>date</code>, not <code>datetime</code>. So why is it displays the time as well?  </p>