title: How to convert varchar to datetime
body: <p>I have a varchar column header (Prod_time) in the [YYYYmmdd hhmmss] format that I am trying to convert to datetime. I need to be able to pull data from a certain number of days, and I would like to be able to convert the varchar to datetime to facilitate this.</p>
  
  <p>Is there a way to convert varchar to datetime? No special formatting of the datetime needed, only a data type conversion. </p>