Re: format query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux