Received: from phoenix.nanospace.com (phoenix.nanospace.com [209.213.199.19]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0P2HZq97418 for ; Wed, 24 Jan 2001 21:17:36 -0500 (EST) (envelope-from dalgoda@ix.netcom.com) Received: (qmail 11804 invoked from network); 25 Jan 2001 02:17:32 -0000 Received: from workstation-209-213-222-98.yy.com (HELO thune.mrc-home.org) (209.213.222.98) by phoenix.nanospace.com with SMTP; 25 Jan 2001 02:17:32 -0000 Received: by thune.mrc-home.org (8.10.0) id f0P2HVr30799; Wed, 24 Jan 2001 18:17:31 -0800 Date: Wed, 24 Jan 2001 18:17:31 -0800 From: Mike Castle To: pgsql-sql@postgresql.org Subject: Re: Problem with Dates Message-ID: <20010124181731.G17481@thune.yy.com> Reply-To: Mike Castle Mail-Followup-To: Mike Castle , pgsql-sql@postgresql.org References: <00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz> <20010124125552.D17481@thune.yy.com> <003f01c08673$75d617e0$0101a8c0@godzone.net.nz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.6i In-Reply-To: <003f01c08673$75d617e0$0101a8c0@godzone.net.nz>; from agree@godzone.net.nz on Thu, Jan 25, 2001 at 03:06:38PM +1300 X-Archive-Number: 200101/345 X-Sequence-Number: 1018 On Thu, Jan 25, 2001 at 03:06:38PM +1300, Glen and Rosanne Eustace wrote: > pressie# select '31/12/2000'::date + '1 year'::timespan; > ?column? > ----------------------------- > 01/01/2002 00:00:00.00 NZDT > (1 row) What are the outputs of select '31/12/2000'::date; select '31/12/2000'::date + '365 days'::timespan; and 364, 363, etc. Not sure if gets you anywhere. But data points. There is an email archive on the postgresql.org website you could search if you think it's been answered before. mrc -- Mike Castle Life is like a clock: You can work constantly dalgoda@ix.netcom.com and be right all the time, or not work at all www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc We are all of us living in the shadow of Manhattan. -- Watchmen