title: How to convert Timestamp to Date Data Type in Google Bigquery
body: <p>I am trying to convert Timestamp data type columns to Date datatype using:</p>
  
  <p><code>bq query -q  --destination_table=NEW_DATE_TABLE --replace "SELECT DATE(CURR_DT) AS CURR_DT from TEST.DATE_TABLE"</code></p>
  
  <p>The new table shows the column as <code>STRING</code> rather than <code>date</code>. Is there a way to convert timestamp to <code>date</code> data type.</p>
  
  <p><a href="https://i.stack.imgur.com/ZmAwu.png" rel="noreferrer">Requested Screenshot</a></p>