title: Alter view sql date
body: <p>I have an assignment to change the existing date format in an existing T-SQL view statement. Where the date format is set to <code>YYYY-MM-DD 00:00:00.000</code> the task is to change is to ALTER VIEW to <code>MM-DD-YY</code> formatting. I'm lost on this one.</p>
  
  <pre><code>USE Ch8_simpleco
  
  ALTER VIEW 
  AS invoice
      SELECT INV_DATE
      SET INV_DATE (MMDDYY)
      FROM dbo.v_cust_invoices;
  </code></pre>