title: filter by first 4 digits of a timestamp value in BigQuery standard SQL
body: <p>I have a variable where the entries are date (timestamp). The exact format is like this: <code>2009-03-01 00:00:00 UTC</code>. </p>
  
  <p>I want to filter all the rows where year is 2009 (first 4 digits of the timestamp). I am using google BigQuery standard SQL. I tried the following:</p>
  
  <pre><code>WHERE LEFT(CAST(incurred_month_timestamp as STING), '4') LIKE 2013
  </code></pre>
  
  <p>If anyone can share the query, it would be helpful. </p>
  
  <p>Thanks. </p>