title: Convert strings into date in SQLite when formatting is not standard
body: <p>I have two database tables named Intra360 and DAILY where the field "Date" is containing date strings in either of the following formatting: </p>
  
  <pre><code>30/01/2012 (dd/mm/yyyy)
  30/01/2012 00:00 (dd/mm/yyyy hh:mm)
  </code></pre>
  
  <p>I would like to execute the following queries to the database: </p>
  
  <pre><code>SELECT MAX(Date) from Intra360 WHERE Date &lt;= "05/04/2013 00:00"
  SELECT MAX(Date) from DAILY WHERE Date &lt;= "05/04/2013"
  </code></pre>
  
  <p>I know that the date formatting is not the proper one YYYY-MM-DD HH:MM but I have been going through SQLite documentations and seen there are some functions (such as "DATE()") to convert strings into dates and more in general to make string manipulation. I have no knowledge of SQL so maybe I'm not even able to implement it properly. Moreover, I cannot touch the data stored in the database so I need to get them making the due manipulation directly through SQL statement. Could anyone help with this? </p>