Re: Week number

On Wed, 2001-11-28 at 13:09, Wodzu wrote:
> I'm novice in PostgreSQL.

Then pgsql-novice is the correct list to ask this kind of question.
> I want to obtain current week number.
> Under PHP I try:
>
> $query = "SELECT EXTRACT(WEEK FROM NOW)";
> $result= pg_exec($dbconn,$query);

select date_part('week', CURRENT_TIMESTAMP);

Markus Bertheau