title: Minus 1 in datetime during execution of loop
body: <p>I have a method to get the <code>datetime()</code> name <code>getdate</code> and this is the query for getting the date: <code>"SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%S') AS serverdt;"</code>;</p>
  
  <p>and I have 365 database just like <code>test01012015 || 01 for month || 01 for day || 2015</code> for year it is a daily database</p>
  
  <p>If I already get the return value for my <code>getdate()</code> method
  how to minus 1 the date every execution of loop?</p>