title: MYSQL: How do I set a date (makedate?) with month, day, and year
body: <p>I have three columns, y, m, and d (year, month, and day) and want to store this as a date.</p>
  
  <p>What function would I use on mySQL to do this?</p>
  
  <p>Apparently makedate uses year and day of year (see below), but I have month. </p>
  
  <p>I know I can use STR_TO_DATE(str,format), by constructing the string from (y,m,d), but I would guess there is an easier way to do it.</p>
  
  <p>REFERENCES</p>
  
  <p><a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_makedate" rel="noreferrer">MAKEDATE(year,dayofyear)</a></p>
  
  <p>Returns a date, given year and day-of-year values. dayofyear must be greater than 0 or the result is NULL.</p>