title: Alter View to change datetime to date in MySQL?
body: <p>How can i write an alter view statement to change a column format(datetime) to date format?</p>
  
  <pre><code>ALTER VIEW my_view AS  
  SELECT `time` AS 'date' Date;
  </code></pre>
  
  <p>The above doesnt work but hoping to get something along those lines.
  Its nots as easy as just changing the data type for tables.</p>
  
  <p>Thanks</p>