Group by YEAR in date
| From: | Faisal Abdullah | Date: | Mon, 28 Oct 2002 14:04:15 +0000 |
| Subject: | Group by YEAR in date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-121692@lists.php.net to get a copy of this message | ||
Hi people,
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.
Thanks.
Regards,
Faisal
______________________________________