title: SQL Date Return If Null Then Blank
body: <p>I currently have the following code: </p>
  
  <pre><code>CASE WHEN CONVERT(DATE, BirthDateTime) IS NULL THEN '' END AS DOB,
  CASE WHEN CONVERT(DATE, ServiceDateTime) IS NULL THEN '' END AS [Admission Date],
  CASE WHEN CONVERT(DATE, DischargeDateTime) IS NULL THEN '' END AS [Discharge Date],
  </code></pre>
  
  <p>It returns: </p>
  
  <p><a href="https://i.stack.imgur.com/rklTZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rklTZ.jpg" alt="enter image description here"></a></p>
  
  <p>What is the best way to still convert the date to Date (original field is datetime) and if it is Null then return blank or ' '</p>
  
  <p>Thanks in advance! </p>