title: How to get Date in proper Format
body: <p>Using the windows shell when i try to query the <code>mmssms.db</code> like </p>
  
  <pre><code>sqlite&gt; select address, date, body from sms;
  </code></pre>
  
  <p>it gives me the date in some weird format, how can i get it in proper Date format. Screen shot is attached.</p>
  
  <p><img src="https://i.stack.imgur.com/XsGJF.png" alt="enter image description here"></p>