Where is that function from? I get an error while trying that? Neil
----- Original Message ----- From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 9:30 PM Subject: RE: Group By > SELECT * > FROM Something > GROUP BY DateSerial(Year([TheDate]),Month([TheDate]),Day([TheDate])) > ORDER BY DateSerial(Year([TheDate]),Month([TheDate]),Day([TheDate])); > > Regards, > Matthew Walker > /* > Cabbage Tree Creative Ltd > Christchurch - New Zealand > > http://www.matthewwalker.net.nz/ > http://www.cabbagetree.co.nz/ > */ > > > -----Original Message----- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 9 April 2002 1:13 p.m. > To: CF-Talk > Subject: Group By > > > I want to run a SQL query that groups by a day for multiple months. > Some of > the dates have times but I want those times ignored. Could someone > suggest > a way to group with just the month/day/year? > > Thanks, > > Neil > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
