title: Between Operator Big Query Standard SQL
body: <p>Using Standard SQL in BQ - as part of a task I want to search for records created between 2pm the previous day &amp; 2pm on current day</p>
  
  <p>I have found </p>
  
  <p><code>SELECT DATETIME_SUB(DATETIME_TRUNC(CURRENT_DATETIME(), DAY), INTERVAL 10 hour)</code>  Gives me 2PM yesterday</p>
  
  <p>SELECT DATETIME_ADD(DATETIME_TRUNC(CURRENT_DATETIME(), DAY), INTERVAL 14 hour)</p>
  
  <pre><code>Gives me 2pm today
  </code></pre>
  
  <p>So, i assumed i could use this in my query</p>
  
  <pre><code>Select * from  
  TableA  
  where CreatedDate Between  
   DATETIME_SUB(DATETIME_TRUNC(CURRENT_DATETIME(), DAY), INTERVAL 10 hour) and DATETIME_ADD(DATETIME_TRUNC(CURRENT_DATETIME(), DAY), INTERVAL 14 hour)
  </code></pre>
  
  <p>However I get the following </p>
  
  <blockquote>
    <p>No matching signature for operator BETWEEN for argument types:
    TIMESTAMP, DATETIME, DATETIME. Supported signature: (ANY) BETWEEN
    (ANY) AND (ANY)</p>
  </blockquote>
  
  <p>Where am i going wrong?</p>