Skip site navigation (1) Skip section navigation (2)

Re: Week number

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Wodzu <wodzu(at)wodzus(dot)prv(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Week number
Date: 2001-11-28 14:13:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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:
> $result= pg_exec($dbconn,$query);

select date_part('week', CURRENT_TIMESTAMP);

Markus Bertheau

In response to


pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-11-28 14:30:46
Subject: Re: Call for platform testing
Previous:From: Albert BartoszkoDate: 2001-11-28 14:07:51
Subject: Rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group