Week number - Mailing list pgsql-hackers

From Wodzu
Subject Week number
Date
Msg-id 9u2k2v$1nff$1@news2.ipartners.pl
Whole thread Raw
Responses Re: Week number
Re: Week number
Re: Week number
List pgsql-hackers
Hi all,

I'm novice in PostgreSQL.
I want to obtain current week number.
Under PHP I try:

$query = "SELECT EXTRACT(WEEK FROM NOW)";
$result= pg_exec($dbconn,$query);

where: $dbconn - successful conection id
But this give me an error message.
Can somebody help me?
Sorry for my english.

Thanks in advice.

Wodzu







pgsql-hackers by date:

Previous
From: Luis Amigo
Date:
Subject: Re: installing 7.2b3 on IRIX 6.5.13
Next
From: Markus Bertheau
Date:
Subject: Re: Week number