title: Date in variable - mysql
body: <p>i would need to help how can i save into my variable <code>@today</code> from <code>CURRENT_DATE()</code> value on <code>VARCHAR</code> type as you can see in first SET row and in the second row in my variable <code>@yesterday</code> i would like to save the value in DATE type.</p>
  
  <pre><code>SET @today=CAST(CURRENT_DATE() AS VARCHAR(50)),
  @yesterday=CAST(DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) AS DATE)
  
  SELECT @today, @yesterday
  </code></pre>
  
  <p>Thanks for your help</p>