title: Why do SQLiteStudio (and others) not display a datetime in human-readable format by default?
body: <p>Today I had to use a SQLite database for the first time and I really wondered about the display of a <code>DATETIME</code> column like <code>1411111200</code>. Of course, internally it has to be stored as some integer value to be able to do math with it. But who wants to see that in a grid output, which is clearly for human eyes?</p>
  
  <p>I even tried two programs, SQLiteStudio and SQLite Manager, and both don't even have an option to change this (at least I couldn't find it).</p>
  
  <p>Of course with my knowledge about SQL it didn't take long to find out what the values mean - this query displays it like I expected:</p>
  
  <pre><code>select datetime(timestamp, 'unixepoch', 'localtime'), * from MyTable
  </code></pre>
  
  <p>But that's very uncomfortable when working with a GUI Tool. So why? Just because? Unix nerds? Or did I just get a wrong impression because I accidentally tried the only 2 Tools which are bad?</p>
  
  <p>(I also appreciate comments on which tools to use or where I can find the hidden settings.)</p>