When dates are stored in epoch timestamps, make them human readable like so:
<div class="remark-highlight"><pre class="language-sql"><code class="language-sql">sqlite> select cmd, dir, datetime(when_run, 'unixepoch', 'localtime') from commands where cmd like 'git submodule%';
</code></pre></div>
Source: <a href="https://stackoverflow.com/questions/14629347/how-to-convert-unix-epoch-time-in-sqlite">Stackoverflow</a>.

When dates are stored in epoch timestamps, make them human readable like so:
sqlite> select cmd, dir, datetime(when_run, 'unixepoch', 'localtime') from commands where cmd like 'git submodule%';

Source: Stackoverflow.


Converting datetime in Sqlite