Re: Extract week from date

2009/5/18 Dani Castaños <dcastanos(at)androme(dot)es>

> Hi again,
>
> I need to extract date grouped by week from an statistics table.
>
> I was trying something like this:
>
> SELECT total_duration, EXTRACT( week from date statistics_date )
> FROM statistics_daily
> GROUP BY EXTRACT( week from date statistics_date ), total_duration;
>
> But it doesn't works... Neither:
>
> SELECT total_duration, statistics_date
> FROM statistics_daily
> GROUP BY EXTRACT( day from statistics_date ), total_duration,
> statistics_date;
>
>
hmmm.. it's not clear what do you want.

why not just something like

SELECT EXTRACT( week from statistics_date ) as week, SUM(
total_duration) as total_duration_sum
FROM statistics_daily GROUP BY 1;

?

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/