title: How to add hours to current date in MySQL
body: <p>I've been tearing my head apart with this SQL statement, i'm trying to add 8 hours to the current day, because the server which is in another country and it updates at 8AM GMT. I want it to update at 12AM GMT hence adding 8 hours to current date, if someone could shed some light or a solution, i would be very thankful :) This is what I've got so far</p>
  
  <pre><code>("SELECT * FROM timetable  WHERE DATE (date) = CURDATE()");
  
  ("SELECT * FROM timetable  WHERE DATE (date) = DATE_ADD(CURDATE(),INTERVAL 8 HOUR)"); 
  </code></pre>
  
  <p>That's what i came up with but it doesn't display anything :(</p>