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

Week number

From: "Wodzu" <wodzu(at)wodzus(dot)prv(dot)pl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Week number
Date: 2001-11-28 12:09:48
Message-ID: 9u2k2v$1nff$1@news2.ipartners.pl (view raw or flat)
Thread:
Lists: 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






Responses

pgsql-hackers by date

Next:From: Larry RosenmanDate: 2001-11-28 13:17:23
Subject: Re: Call for platform testing
Previous:From: mlwDate: 2001-11-28 11:58:25
Subject: Re: Possible bug in new VACUUM code

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