title: Format string to datetime using Spark SQL
body: <p>I am trying to convert and reformat a date column stored as a string using spark sql from something that looks like this...</p>
  <pre><code>30/03/20 02:00
  </code></pre>
  <p>to something that is a datetime column and looks like this...</p>
  <pre><code>2020-03-30 02:00 ('YYYY-MM-dd HH:mm')
  </code></pre>
  <p>I am not using python but simply writing sql in DBeaver directly to a spark datalake. Any help is greatly appreciated.</p>