RE: [PHP] Group by YEAR in date

2002-10-29 Thread Faisal Abdullah
Thanks guys. It worked. Regards, Faisal > -Original Message- > From: 1LT John W. Holmes [mailto:holmes072000@;charter.net] > Sent: Monday, October 28, 2002 10:17 PM > To: Faisal Abdullah; [EMAIL PROTECTED] > Subject: Re: [PHP] Group by YEAR in date > > > &g

Re: [PHP] Group by YEAR in date

2002-10-28 Thread 1LT John W. Holmes
> I have a table (postgres), with a date field (-mm-dd). How do I group by > year? > > 'select sum(profit) from loan group by apply_date' would group by the DAY, > not year. SELECT SUM(profit) FROM load GROUP BY YEAR(apply_date) ---John Holmes... -- PHP General Mailing List (http://www.php

Re: [PHP] Group by YEAR in date

2002-10-28 Thread Marek Kilimajer
In mysql, I would need to select an extra column SELECT SUM(profit), YEAR(apply_date) AS year FROM loan GROUP BY year Faisal Abdullah wrote: Hi people, I have a table (postgres), with a date field (-mm-dd). How do I group by year? 'select sum(profit) from loan group by apply_date' would gr