title: Cast Function to display only the month and day from a datetime
body: <pre><code>SELECT 
      DateAdded, 
      Cast(DateAdded AS Date) AS DateAddedV1, 
      Cast(DateAdded AS Time) AS DateTime, 
      SELECT CAST(DateAdded AS Date(mm:dd) AS OrderDate
  FROM Products
  </code></pre>
  
  <p>I am a beginner with SQL and I am trying to return the <code>DateAdded</code> column as <code>OrderDate</code> with only the month and the day but I cannot seem to get the syntax right. I appreciate anyone's assistance.</p>