Re: format query

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: "pgsql-php(at)postgresql(dot)org" <pgsql-php(at)postgresql(dot)org>
Subject: Re: format query
Date: 2005-03-09 12:37:40
Message-ID: 5.2.1.1.0.20050309073647.00aaae00@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • format query at 2005-03-09 12:22:53 from enzo venegas palacios

Browse pgsql-php by date

  From Date Subject
Next Message Todd Lewis 2005-03-09 15:07:57 Re: format query
Previous Message enzo venegas palacios 2005-03-09 12:22:53 format query