title: Mysql now () + INTERVAL 1 DAY returns 0000-00-00 00:00:00 on live server
body: <p>I was working on a project. I just uploaded it to my live server. When users post a job, I'm using the mysql now() + INTERVAL with the job delivery time to set an expiration so that I can then select expired jobs without selecting all of the jobs. this works fine in my local development environment but on live it inserts 0000-00-00 00:00:00 in db.</p>
  <p>Any suggestions?</p>
  <pre><code>$job['delivery_time'] = 8; // can have a number from 1 to 29
  
  $sql = &quot;INSERT INTO jobs(job_id, posted_by, title, category_id, description, required_freelancers, budget, delivery_time, job_expiration, date_posted, updated_at) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, now() + INTERVAL &quot; . $job['delivery_time'] . &quot; DAY, ?)&quot;;
  $stmt = mysqli_stmt_init($db);
  mysqli_stmt_prepare($stmt, $sql);
  
  $current_time = date('U');
  mysqli_stmt_bind_param($stmt, 'sssisisiii', $job['id'], $user_id, $job['title'], $job['category'], $job['description'], $job['required_freelancers'], $job['budget'], $job['delivery_time'], $current_time, $current_time);
  mysqli_stmt_execute($stmt);
  mysqli_stmt_close($stmt);
  </code></pre>