Re: Group by range of dates
Alex Harford Wrote:
> I want to separate them into bins. 2006 Dec, 2006
> Nov, ... 2005 Dec, 2005 Nov, 2005 Oct ... all the
> way down.
SELECT
DATE_FORMAT(bdate, '%Y-%m') ym,
COUNT(*)
FROM foo
GROUP BY ym
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
December 20, 2006 01:50PM
December 20, 2006 05:04PM
December 20, 2006 05:21PM
Re: Group by range of dates
December 21, 2006 08:52AM
December 22, 2006 11:14AM
December 05, 2008 12:19AM
December 05, 2008 06:00PM
December 08, 2008 12:49PM
December 08, 2008 01:32PM
December 20, 2008 12:40AM
December 20, 2008 08:04PM
December 21, 2008 12:18AM
December 21, 2008 09:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.