title: Unix time to datetime google bigquery?
body: <p>I'm trying to transfer a postgres query to Google BigQuery but I can't seem to find out how to transfer this part:</p>
  
  <pre><code>date_trunc('Month',to_timestamp(created_utc)) 
  </code></pre>
  
  <p>I've tried everything <a href="https://stackoverflow.com/questions/43983093/how-to-convert-an-epoch-timestamp-to-a-date-in-standard-sql?utm_medium=organic&amp;utm_source=google_rich_qa&amp;utm_campaign=google_rich_qa">here</a> but it turns the unix timestamp into 1970-01-01 instead of what the real timestamp should be (2014-etc-etc ...)</p>