Date fields in Postgres & PHP

From: Date: Thu, 21 Sep 2000 18:27:38 +0000
Subject: Date fields in Postgres & PHP
Groups: php.db 
Request: Send a blank email to php-db+get-3029@lists.php.net to get a copy of this message
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

« previous php.db (#3029) next »