Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f031m8726001 for ; Tue, 2 Jan 2001 20:48:08 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from fep03-svc.mail.telepac.pt (fep03-svc.mail.telepac.pt [194.65.5.202]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f030Hm717827 for ; Tue, 2 Jan 2001 19:17:54 -0500 (EST) (envelope-from info@megabenfica.com) Received: from servidor ([194.65.192.158]) by fep03-svc.mail.telepac.pt (InterMail vM.4.01.02.27 201-229-119-110) with SMTP id <20010103002431.EXAU27565.fep03-svc.mail.telepac.pt@servidor> for ; Wed, 3 Jan 2001 00:24:31 +0000 Message-ID: <001201c0751b$39405ca0$8902a8c0@centro.com> From: "Leo Xavier" To: Subject: order by day or month, etc Date: Wed, 3 Jan 2001 00:22:14 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/25 X-Sequence-Number: 686 Hello first time I post something... good morning everyone! short presentation: Leo Xavier, Lisbon - Portugal, 17 years, my home-made site: www.megabenfica.com Sql7, win 2000... The question: How for example do I select all entrys from a certain month (of a certain year, of course) ? Or from a certain day? And how from a certain period, between day X and Y, i.e? The solution i found is to create three columns in the table: one with the day, a second with the month, a thir with the year... but this really is a little bit unprofessional ... doing this: SELECT to_char(field, 'DD/MM/YYYY') AS new_date as Francis Solomon said, didnt work... "unrecognized function" ... can anyone help me?? Leo Xavier