Postgres Pro
Downloads
Home   >   mailing lists

How to get number of the week from datetime? - Mailing list pgsql-general

From Hojdar Karel Ing.
Subject How to get number of the week from datetime?
Date
Msg-id F0F2C79F20CFD2119D07080009DC528431E153@NT_MAIN_SG
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Marcin Mazurek - Multinet SA - Poznan
Date:
Subject: Re: [GENERAL] Image data type
Next
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] Database synchronisation over the internet...