SQL Server 2K, sorry. Everett, Al (NIH/NIGMS) [C] wrote: > What RDBMS? > > In Oracle you can do something like this: > > SELECT extract(month from startdate) as event_month, extract(day from > startdate) as event_day, event_title > FROM events > WHERE active=1 > ORDER BY startdate ASC > > > > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 20, 2006 10:13 AM > To: CF-Talk > Subject: grouping by date > > I have an event table that I need to output the data in a specific > fashion, based on dates, like so: > > April > 19th > event1 > event2 > event3 > 26th > event4 > event5 > 30th > event6 > event7 > event8 > May > 1st > event10 > event11 > 17th > event12 > > June > > etc > > I have the date stored as a date type in the DB. What's the best way to > go about outputting the events, grouped as above? I've come up with > some elaborate workarounds, but they seem clunky and not very > maintenance-friendly. > > For argument's sake, let's say the current select statement looks like > this: > > SELECT startdate, event_title > FROM events > WHERE active=1 > ORDER BY startdate ASC > > Thanks, > > Ray > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
