Re: Date fields in Postgres & PHP
| From: | Jeff MacDonald | Date: | Thu, 21 Sep 2000 21:07:34 +0000 |
| Subject: | Re: Date fields in Postgres & PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3042@lists.php.net to get a copy of this message | ||
iirc ,use the datepart function .
On Thu, 21 Sep 2000, Edgar de Jesus Galicia wrote:
> Hi!!!
>
> I am using php with postgres sql, it works fine, but i need to make a
> query, where selects all the regs wich where captured in a particular
> month,
> in the table i have a field called capdate wich is date type...
>
> the question is, how can obtain the month (or even only the day or year)
> in my query (select * from table where...(???) )
>
> Thanks for your help
>
> Greetings
>
>
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose