From: | "Todd Lewis" <lewis-todd(at)sbcglobal(dot)net> |
---|---|
To: | enzovenegas(at)mixmail(dot)com, "pgsql-php(at)postgresql(dot)org" <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: format query |
Date: | 2005-03-09 15:07:57 |
Message-ID: | 422EA0CD.3616.7C54045@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
use the to_char function to specify the format in your where clause.
>
> 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
>
> I hope somebody can help me.
>
> enzo
> ---------------------------------------------------------
> ¿Quieres saber cómo te ira en el amor? ¿en el trabajo? Nosotros te lo contamos http://astrocentro.mujeractual.com/ya
> ADSL + Llamadas 24 horas: desde 28,95 /mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2005-03-09 15:16:43 | Re: format query |
Previous Message | Frank Bax | 2005-03-09 12:37:40 | Re: format query |