subject:"Group by for datetime"

Re: Group by for datetime

2004-04-16 Thread Paul DuBois

At 17:22 -0400 4/16/04, Mike Morton wrote: I have a table: CREATE TABLE `moviehits` ( `title` varchar(5) NOT NULL default '', `movie` varchar(4) NOT NULL default '', `hit_date` datetime NOT NULL default '-00-00 00:00:00', `ip` varchar(15) NOT NULL default '', `listing_id` int(10) unsi

Group by for datetime

2004-04-16 Thread Mike Morton

I have a table: CREATE TABLE `moviehits` ( `title` varchar(5) NOT NULL default '', `movie` varchar(4) NOT NULL default '', `hit_date` datetime NOT NULL default '-00-00 00:00:00', `ip` varchar(15) NOT NULL default '', `listing_id` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; T