Re: [GENERAL] How to get number of the week from datetime?

"Hojdar Karel Ing." wrote:

> Hi,
>
> how I can get some agregates (avg, min, max) for whole week (in specified
> year)?
> For example from table with two columns : time datetime and value float8.
> And I want to get average of value based on whole weeks. If I try to use
> date_part('week',time) - Postgresql doesn't recognize word 'week'.
>
> Thanks Karel
>
> ************

select date_part('dow',current_date);

If you are looking for a function to calculate the no. week of the year...
try the attached function.

José