Received: from nwcst315.netaddress.usa.net (nwcst315.netaddress.usa.net [204.68.23.60]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f25IxDx22263 for ; Mon, 5 Mar 2001 13:59:14 -0500 (EST) (envelope-from rocael@usa.net) Received: (qmail 18951 invoked by uid 60001); 5 Mar 2001 17:55:16 -0000 Message-ID: <20010305175516.18950.qmail@nwcst315.netaddress.usa.net> Received: from 204.68.23.60 by nwcst315 for [216.230.140.134] via web-mailer() on Mon Mar 5 17:55:16 GMT 2001 Date: 5 Mar 2001 10:55:16 MST From: To: pgsql-sql@postgresql.org Subject: count number of weeks?? X-Mailer: USANET web-mailer () Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f25IxEx22264 X-Archive-Number: 200103/53 X-Sequence-Number: 1698 Hi all! I wonder how in PG7.0.2 I can count the number of weeks from a date field that I have in a table, lets say: table trial has in its fields start_date as sysdate(), and now I want to do a select that will give me the number of weeks from now [sysdate()] to the start_date. Thanks for the help! Rocael. ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1