title: MySQL Datetime displays 0:00:00
body: <p>When I run a query to display a datetime in MySQL, the time displayed is sometimes 0:00:00, even though when I query for the hour, minute, or second, I get the values I would expect.</p>
  
  <p><a href="https://i.stack.imgur.com/vKdwP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vKdwP.jpg" alt="datetime query and response"></a></p>
  
  <p>As you can see, the stored time is 9:24:23, but the displayed time is 0:00:00.</p>
  
  <p>The column datetime has a data type datetime. Is there a way to get my queries to display the correct time without doing a terrible concat(hour,minute,second) workaround?</p>
  
  <p>EDIT:
  Sometimes, I get the datetime as expected, and I don't see any difference between the times that display and those that don't.</p>
  
  <p><a href="https://i.stack.imgur.com/BHVRw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BHVRw.jpg" alt="enter image description here"></a></p>
  
  <p>Here's the table setup:</p>
  
  <p><a href="https://i.stack.imgur.com/r9hrO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r9hrO.jpg" alt="enter image description here"></a></p>