Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to get number of the week from datetime?

How to get number of the week from datetime?

From
"Hojdar Karel Ing."
Date:
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.

    Thanks   Karel