Converting datetime in Sqlite
1 min read
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.