title: Convert a date and time string in the format YYYY-MM-DD HH:MM:SS in SQL
body: <p>Is there any way to convert "A date and time string in the format YYYY-MM-DD HH:MM:SS” using legacy SQL syntax or standard SQL syntax in BigQuery.</p>
  
  <p>For eg. "November 9, 2017" to 2017-11-09 00:00:00</p>