title: SQL: Date format and Case Statement Question
body: <p>I have some dates in the following format :   <code>YYYY-MM-DD HH:MM:SS</code>’ </p>
  
  <p>I would like it to be in this format: <code>YYYY-MM-DD</code></p>
  
  <p>Also, I am selecting another field with true and false values which I would like to convert to 0's and 1's</p>
  
  <p>Is this possible?</p>
  
  <p><strong>I am doing this in a dts package and noticed one more thing:</strong></p>
  
  <p>The last field I am selecting is a guid which is enclosed in {brackets} is there a way to take the brackets out</p>