Received: from ENDOR.MINE.NU (dialup-home-bartschm.psi.cl [200.29.14.67]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0E0Mhp88379 for ; Sat, 13 Jan 2001 19:22:44 -0500 (EST) (envelope-from bartschm@psi.com) Received: from psi.com (IDENT:synflood@ENDOR.PSINET.CL [127.0.0.1]) by ENDOR.MINE.NU (8.11.0/8.11.0) with ESMTP id f0E0O8L03964 for ; Sat, 13 Jan 2001 21:24:12 -0300 Message-ID: <3A60F1A8.794AAE3B@psi.com> Date: Sat, 13 Jan 2001 21:24:08 -0300 From: bartschm@psi.com Organization: PSINet Latin America X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16-22 i686) X-Accept-Language: en, es MIME-Version: 1.0 To: Postgres SQL list Subject: how to select a time frame on timestamp rows. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/127 X-Sequence-Number: 788 Hello, today i was trying to perform a query on a database using a time stamp field, i need to get all records which belong to year 2000, month 11, is there any other way to doit, or is this the pgsql way? , actually i'm using a query like this: select User_Name from tbacct where acct_timestamp like '2000-11%' group by User_Name; on MySQL i use this select User_Name from tbAcct where month (Acct_Timestamp) = 11 group by User_Name; (on mysql i was't worried about year yet) is anything like the month function from mysql on pg-sql? sorry if the question is to obvious, but i was reading the docs and can't find an answer. Regards!