Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e65CtXS18674 for ; Wed, 5 Jul 2000 08:55:37 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id PAA16179 for ; Wed, 5 Jul 2000 15:55:24 +0300 Date: Wed, 5 Jul 2000 15:55:24 +0300 (EEST) From: Antti Linno To: pgsql-sql@postgresql.org Subject: Aww, sorry (last day of month) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200007/40 I thought, I finished that group by theme. What i ment was, that I have information about workers, and I have to make report on them. Report should contain status about workers with the restriction , that the data is about last day of the month. I use perl as a scripting language, and how the hell should I know how many days were in that particular month (28,29,30,31) :). If there are no means by doing it in sql, I write a code to ask for a , mmm, special day. *sigh* Maybe something with date_trunc? Thanx for discussion though. Antti, greetings from estionia :P