title: php - Change curdate format
body: <p>As far as I can understand the curdate() mysql function returns a date like this:</p>
  
  <pre><code>'YYYY-MM-DD'
  </code></pre>
  
  <p>How can I do so it select it like this instead:</p>
  
  <pre><code>'YYYY/MM/DD'
  </code></pre>
  
  <p>I have this query:</p>
  
  <pre><code>$sql = mysql_query("SELECT SUM(value) from xeon_stats_clicks WHERE typ='4' AND curdate() - interval 7 day &gt;= data ") or die(mysql_error());
  </code></pre>
  
  <p>Although my "data" row in the database is formatted like this: "YYYY/MM/DD"</p>
  
  <p>Therefore, how can I change the query to select the date format like that?</p>