title: Date function in standard SQL in Google bigquery
body: <p>What are the date functions like (YEAR(), MONTH(), DATEADD(), DATEDIFF(),...) in standard SQL of Goolge bigquery?</p>
  
  <p>I used functions <a href="https://cloud.google.com/bigquery/query-reference" rel="nofollow">here</a> when --use_legacy_sql is true, but they don't work with standard SQL.</p>