RE: [PHP] Group by YEAR in date
| From: | Faisal Abdullah | Date: | Tue, 29 Oct 2002 08:25:10 +0000 |
| Subject: | RE: [PHP] Group by YEAR in date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-121819@lists.php.net to get a copy of this message | ||
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; php-general@lists.php.net
> Subject: Re: [PHP] Group by YEAR in date
>
>
> > I have a table (postgres), with a date field (yyyy-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.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
______________________________________