title: Difference between two dates in dates using Google bigquery?
body: <p>How can I get the difference in days between 2 timestamp fields in Google Big Query? </p>
  
  <p>The only function I know is <code>Datediff</code> which only works in Legacy SQL but I'm in Standard SQL. </p>
  
  <p>For example: the difference between 20180115 to 20180220 is 36 days.</p>