MYSQL: How do I set a date (makedate?) with month, day, and year

Question

Hi?

I have three columns, y, m, and d (year, month, and day) and want to store this as a date.

What function would I use on mySQL to do this?

Apparently makedate uses year and day of year (see below), but I have month.

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.

REFERENCES

MAKEDATE(year,dayofyear)

Returns a date, given year and day-of-year values. dayofyear must be greater than 0 or the result is NULL.

Answer 1

I believe you can use a string in the proper format:

UPDATE table SET my_date = '2009-12-31';

Edit: Yeah you can, just verified it in MySQL 5.1.