I have an events table the date is separated into 3 columns.

Code MySQL:
CREATE TABLE IF NOT EXISTS `wc_events` (
  `event_id` int(5) unsigned NOT NULL auto_increment,
  `event_day` int(2) NOT NULL default '0',
  `event_month` int(2) NOT NULL default '0',
  `event_year` varchar(4) NOT NULL default '0',
  `event_title` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM;

I am trying to format the date using MySQL's DATE_FORMAT function. The trouble comes when I try to combine the three columns together to put into the function.

Something like this:

Code MySQL:
SELECT DATE_FORMAT(`event_year``event_month``event_day`,'%Y-%c-%e'') as format_t FROM wc_events

But this doesn't work. If anybody could help I would be very greatful.