title: Convert Unix time with PowerShell
body: <p>I am parsing an SQLite database using the PowerShell <a href="http://en.wikipedia.org/wiki/SQLite" rel="noreferrer">SQLite</a> module, and a couple of the return values are created and modified, both of which are in Unix time.</p>
  
  <p>What I would like to do is somehow convert that into "human time". I have removed some of the other SQL queries for ease of reading.</p>
  
  <pre><code>Import-Module SQLite
  mount-sqlite -name GoogleDrive -dataSource E:\Programming\new.db
  $cloud_entry = Get-ChildItem GoogleDrive:\cloud_entry
  
  foreach ($entry in $cloud_entry)
  {
      $entry.created
  }
  </code></pre>
  
  <p>The output looks like a large column of Unix timestamps:</p>
  
  <pre><code>1337329458
  </code></pre>
  
  <p><em>Update</em>: I ultimately went with the following:</p>
  
  <pre><code>$ctime = $entry.created
  [datetime]$origin = '1970-01-01 00:00:00'
  $origin.AddSeconds($ctime)
  </code></pre>