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
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
