title: mysql Date is returning strange characters
body: <p>So I have this large query that was working fine until I added the jobs.deliveryDate. Query still has no errors but when I echo out my value it echoes these strange characters. I'm wondering if it has something to do with the MySQL datatype. This variable has a datatype of Date, but I'm able to pull in a datatype of Datetime just fine. <a href="https://i.stack.imgur.com/9T7v6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9T7v6.jpg" alt="Screen Shot of characters"></a></p>
  
  <pre><code>$query = $connect-&gt;prepare("
      (SELECT 
      jobs.jobID,
      jobs.jobName,
      jobs.pdf,
      jobs.deliveryDate,
      jobstatus.status,
  
      rooms.roomID, 
      rooms.roomName, 
      rooms.assemblyS,
      rooms.assemblyF,
      rooms.assembledF,
      rooms.assemblyNeeded,
      rooms.woodType,
      rooms.finishType,
      rooms.finishColor,
      rooms.numberOfBoxes,
      rooms.isRush,
      rooms.description,
  
      jobnotes.note
      FROM jobs 
      LEFT JOIN rooms ON jobs.jobID = rooms.jobID 
      LEFT JOIN jobnotes ON jobnotes.jobID = jobs.jobID
      LEFT JOIN jobstatus ON jobstatus.statusOrder = jobs.statusOrder
      WHERE (rooms.assemblyNeeded = 1) AND ((rooms.isRush = 1 AND rooms.assemblyF = 0) OR (rooms.isRush = 1 AND rooms.assemblyF IS NULL))
      GROUP BY rooms.roomID)
  
      UNION ALL
  
      (SELECT 
      jobs.jobID,
      jobs.jobName,
      jobs.pdf,
      jobs.deliveryDate,
      jobstatus.status,
  
      rooms.roomID, 
      rooms.roomName, 
      rooms.assemblyS,
      rooms.assemblyF,
      rooms.assembledF,
      rooms.assemblyNeeded,
      rooms.woodType,
      rooms.finishType,
      rooms.finishColor,
      rooms.numberOfBoxes,
      rooms.isRush,
      rooms.description,
  
      jobnotes.note
      FROM jobs 
      LEFT JOIN rooms ON jobs.jobID = rooms.jobID 
      LEFT JOIN jobnotes ON jobnotes.jobID = jobs.jobID
      LEFT JOIN jobstatus ON jobstatus.statusOrder = jobs.statusOrder
      WHERE ((rooms.assemblyNeeded = 1 AND jobstatus.statusOrder &gt;= 0 AND rooms.assemblyF IS NULL)
      OR (rooms.assemblyNeeded = 1 AND jobstatus.statusOrder &gt;= 0 AND rooms.assemblyF = 0))
      AND ((rooms.isRush = 0 AND rooms.assemblyF = 0) OR (rooms.isRush = 0 AND rooms.assemblyF IS NULL))
      GROUP BY jobs.jobName, rooms.finishColor 
      ORDER BY jobs.statusOrder = 7 DESC, deliveryDate, jobName, finishType LIMIT 50)");
  if(!$query) {
      echo("Query Failed Because " . mysqli_error($connect));
  };
  
  $query-&gt;execute();
  $result = $query-&gt;get_result();
  
  
  while($row = mysqli_fetch_assoc($result)) {
      $deliveryDate = $row['deliveryDate'];
      echo $deliveryDate;
  }
  </code></pre>