title: VB.NET convert 24hours mySQL TIME() to 12hours format
body: <p>Okay, I know there are similar post to this. But all I can see is they are using DATETIME() data type, mine is TIME() only.</p>
  
  <p>I manage to store time using mysql time(now()). The format it stored is in 24hours format.</p>
  
  <p>When I retrieve its value to some label in VB.NET I need to display it in 12 hours format. What I have done so far is the code below. but no luck.</p>
  
  <pre><code> dataSet = New DataSet
          adapter.SelectCommand.CommandText = "SELECT timein_pm from dtr WHERE cats_id='" &amp; Trim(lblId.Text) &amp; "'"
          adapter.Fill(dataSet)
  
          Label6.Text = dataSet.Tables(0).Rows(0)("timein_pm").ToString("hh:mm tt")
  </code></pre>
  
  <p>How do I do it? Also is it possible to do it via mySQL time format or something? </p>
  
  <p>EDITED:</p>
  
  <p>Database Values:</p>
  
  <pre><code>id        date          timein_pm        id
  57      2013-12-04       15:24:13       0828
  </code></pre>