title: Null values while converting string to datetime with pyspark
body: <p>I have recently started working with pyspark on databricks and it's funny how I have been getting NULL values when converting the following string to DateTime data type. I have checked several articles here on how to do that but none of them seem worked for me.</p>
  <p>sample data</p>
  <pre><code>    invoiceId  quantity invoicedate
       001         34     12/1/2010 8:26
       003         10     12/2/2010 8:26
       004         10     30/2/2010 8:26
  </code></pre>
  <p>I am trying to convert invoicedate (string datatype) into DateTime datatype using pyspark</p>