X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A9823A498E for ; Fri, 19 Nov 2004 06:08:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80352-02 for ; Fri, 19 Nov 2004 06:07:59 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 494723A497E for ; Fri, 19 Nov 2004 06:07:58 +0000 (GMT) Received: (qmail 7735 invoked from network); 19 Nov 2004 06:07:57 -0000 Received: from pcp03902740pcs.nash01.tn.comcast.net (HELO ?192.168.0.114?) (68.53.108.239) by 0 with SMTP; 19 Nov 2004 06:07:57 -0000 In-Reply-To: <87y8gy2xr1.fsf@stark.xeocode.com> References: <419D0DC6.5080504@candoltd.com> <87y8gy2xr1.fsf@stark.xeocode.com> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <5A709098-39F1-11D9-95C2-000D93AE0944@sitening.com> Content-Transfer-Encoding: 7bit Cc: PgSQL - SQL From: Thomas F.O'Connell Subject: Re: Comparing Dates Date: Fri, 19 Nov 2004 00:07:55 -0600 To: Greg Stark X-Mailer: Apple Mail (2.619) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/185 X-Sequence-Number: 19504 Ha. Why so it is. :) -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Nov 18, 2004, at 11:50 PM, Greg Stark wrote: > "Thomas F.O'Connell" writes: > >> select 2004-06-08; >> ?column? >> ---------- >> 1990 >> >> I'm not exactly sure how the bare string is converted internally, but >> it's >> clearly not a complete date like you're expecting. > > What string? That's just integer arithmetic. > > -- > greg