title: How do I extract just the date from a SQL datetime value in SSIS?
body: <p>How do I convert a datetime to just a date in SSIS?</p>
  
  <p>I'm trying to perform an aggregate query which will group by a particular date.  In order to do that, I'm trying to extract just the date portion of the timestamp(stored as a datetime) so I can perform the GROUP BY on the next step.</p>
  
  <p>I've looked at the DATEPART function, but it looks like I would have to call it multiple times to retrieve the month, date and year, concatenate them together and then parse the new date.  There has got to be a better way to do this.</p>