I have an events table the date is separated into 3 columns.
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:
But this doesn't work. If anybody could help I would be very greatful.