title: How do I round the milliseconds to seconds of timestamp in BigQuery?
body: <p>I'm trying to remove the millisecond off my timestamp and in doing so, rounding the value. </p>
  
  <pre><code>
  From this: 2019-11-11 19:10:57.981 UTC
  To this: 2019-11-11 19:10:58 UTC```
  
  Yes, I want the second rounded when truncated. 
  
  
  </code></pre>