> -----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
> > I have a table (postgres), with a date field (yyyy-mm-dd). How
> do I group
> > 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.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php