title: Amazon Athena: Convert bigint timestamp to readable timestamp
body: <p>I am using Athena to query the date stored in a bigInt format. I want to convert it to a friendly timestamp. </p>
  
  <p>I have tried: </p>
  
  <pre><code>    from_unixtime(timestamp DIV 1000) AS readableDate
  </code></pre>
  
  <p>And </p>
  
  <pre><code>     to_timestamp((timestamp::bigInt)/1000, 'MM/DD/YYYY HH24:MI:SS') at time zone 'UTC' as readableDate
  </code></pre>
  
  <p>I am getting errors for both. I am new to AWS. Please help!</p>