Results 1 to 12 of 12
Apr 22, 2011, 03:40 #1
- Join Date
- Feb 2008
- 0 Post(s)
- 0 Thread(s)
Formatting date in 3 different columns
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.