Returns the date as year, month, and day.
specifies the year.
specifies the month.
specifies the day.
select makedate(2013, 10, 30);
30OCT2013
select makedate(y, m, d) from adate;