title: Convert DATE to TIMESTAMP on BigQuery/StandardSQL
body: <p>I am querying a table on BigQuery that has a field in the 'DATE' format. I want to read this in the 'TIMESTAMP' format. I tried converting the DATE to an integer and then converting into a TIMESTAMP but doesn't seem to work.</p>