title: Bigquery - select timestamp as human readable datetime
body: <p>How to select timestamp(stored as seconds) as human readable datetime in Google Bigquery?</p>
  
  <p><strong>schema</strong></p>
  
  <pre><code>id(STRING) | signup_date(TIMESTAMP)
  </code></pre>
  
  <p>I wrote a query using <code>DATE</code> function, but getting error</p>
  
  <pre><code>SELECT DATE(create_date) FROM [accounts] 
  </code></pre>
  
  <blockquote>
    <p>Error: Invalid function name: DATE; did you mean CASE?</p>
  </blockquote>
  
  <p>Thanks!</p>