Re: format query - Mailing list pgsql-php

From Frank Bax
Subject Re: format query
Date
Msg-id 5.2.1.1.0.20050309073647.00aaae00@pop6.sympatico.ca
Whole thread Raw
In response to format query  ("enzo venegas palacios" <enzovenegas@mixmail.com>)
List pgsql-php
At 07:22 AM 3/9/05, enzo venegas palacios wrote:
>I am trying to build a query sql that select all rows in my table with a
>spesific month (format timestamp, yyy-mm-dd hh:mm:ss), for example, all of
>january, select * from table where field_date = 01.
>but i don't know the specific query


WHERE date_part('month',field_date) = 01


pgsql-php by date:

Previous
From: "enzo venegas palacios"
Date:
Subject: format query
Next
From: "Todd Lewis"
Date:
Subject: Re: format query