title: Conversion to Time 12 hour Format From String containing Time in 24 hour format
body: <p>I have a <code>varchar(5)</code> column in a table which contains the hour and minutes in 24 hour format time. I want to convert this 24 hour format to 12 hour format and finally embed this 12 hour format time into a DateTime Variable along with a Date value. Below is an example of demonstration.</p>
  
  <p>For Example </p>
  
  <blockquote>
    <p>8:18 should be converted into 8:18:00 AM and then should be embedded
    with a Date like 8/10/2012 8:18:50 AM to be able to store in DateTime
    column of DB.</p>
  </blockquote>
  
  <pre><code>22:20......10:20:00 PM.......8/10/2012 10:20:00 PM   
  </code></pre>
  
  <p>The Date will not be current date it can be any date value like 8/8/2012 or 7/8/2012</p>