Received: from lucas.mandanet.ch (lucas.mandanet.ch [195.15.14.8]) by hub.org (8.8.8/8.7.5) with SMTP id EAA29814 for ; Mon, 17 Aug 1998 04:53:59 -0400 (EDT) Received: from thomas.mandanet.ch (thomas.mandanet.ch [195.15.14.68]) by lucas.mandanet.ch (NTMail 3.02.13) with ESMTP id ca010324 for ; Mon, 17 Aug 1998 10:58:38 +0100 Message-ID: <35D7F0FA.4C48F4C9@mandanet.ch> Date: Mon, 17 Aug 1998 10:59:38 +0200 From: Jerome Knobl Organization: MandaNET X-Mailer: Mozilla 4.04 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: function year! Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, I have a timestamp value, and I'm tring to get only the year, the month or the day. I'm using the function now() to put some value inside. I tried the function year(..) (select year(thedate) from mytable;) but that function are not define! I'm looking for a simple way to get my informations? Thank. Jérôme Knöbl, MandaNEt, Switzerland