title: Just for SQLite, is there an easy way to convert a column of text (like 21-Sep-2022) into a valid date format while query?
body: <p>Just for SQLite, is there an easy way to convert a column of text (like 21-Sep-2022) into valid date format while query?</p>
  <p>I know it's easy for other DBs, such as <a href="https://en.wikipedia.org/wiki/Microsoft_SQL_Server" rel="nofollow noreferrer">SQL Server</a> and <a href="https://en.wikipedia.org/wiki/Oracle_Database" rel="nofollow noreferrer">Oracle</a>, to do so. They have existing function. I'm now meet the same situation in operating SQLite. But I did not find any &quot;cast&quot;, &quot;convert&quot; or &quot;date&quot; function that could work and get a proper result.</p>
  <p>I've tried DATE(), and it seems the text is not recognized and only NULL returns.</p>