Received: from bering.webline.dk (83.adsl0.kh.worldonline.dk [213.237.10.83]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4BIGEA70752 for ; Fri, 11 May 2001 14:16:14 -0400 (EDT) (envelope-from kar@webline.dk) Received: from bering (localhost [127.0.0.1]) by bering.webline.dk (8.11.2/8.10.2/SuSE Linux 8.10.0-0.3) with SMTP id f4BIFrX02042; Fri, 11 May 2001 20:15:53 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Kaare Rasmussen To: Cwhisperer , pgsql-sql@postgresql.org Subject: Re: number of days in a month Date: Fri, 11 May 2001 20:15:53 +0200 X-Mailer: KMail [version 1.2] References: <11781844085.20010511081908@vo.lu> In-Reply-To: <11781844085.20010511081908@vo.lu> MIME-Version: 1.0 Message-Id: <01051120155301.00699@bering> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/102 X-Sequence-Number: 2918 > does it exist a date function to determine the number of days in a > Select, knowing a specifique date ? January, 2001: select '2001-2-1'::datetime - '2001-1-1'::datetime; -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@webline.dk