title: Convert time in hh:mm:ss AM(PM) format (sql)
body: <p>How do I convert time :  ' 8:02:24 AM ' into ' 08:02:24 AM ' so that all the time in a particular column is of fixed length.</p>
  
  <p>I tried using different style values in convert function but couldn't get my desired result.</p>