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 C9D645E48B9 for ; Sat, 4 Sep 2004 04:44:06 +0100 (BST) 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 02566-02 for ; Sat, 4 Sep 2004 03:44:01 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 215F25E4F9C for ; Sat, 4 Sep 2004 04:25:00 +0100 (BST) Received: from jdoherty.net (cdm-208-180-124-109.gtwn.cox-internet.com [208.180.124.109]) by svr4.postgresql.org (Postfix) with SMTP id 643EF5B0675 for ; Fri, 3 Sep 2004 14:38:46 +0000 (GMT) Received: (qmail 29037 invoked from network); 3 Sep 2004 14:47:57 -0000 Received: from unknown (HELO PCDOHERTY) (172.16.1.21) by 172.16.1.21 with SMTP; 3 Sep 2004 14:47:57 -0000 Message-ID: <000401c491c3$6f4ca240$68363c90@ad.tri.sbc.com> From: "James M Doherty" To: Subject: HOW TO HANDLE ZEROS IN DATE FIELD? Date: Fri, 3 Sep 2004 09:36:44 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=LINES_OF_YELLING, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200409/77 X-Sequence-Number: 18923 I have a project that is taking input from another system. I have certain columns defined as 'Date' Columns. On input I will get '000000' in this field which causes the insert to fail. I have read the docs on default and it is unclear to me if this will work. Does anyone have experience in solving this problem. The other alternative I thought of was to write a trigger to fix it ?? James M Doherty jim@jdoherty.net Georgetown, TX 78626 "There is no luck without discipline" IRISH PROVERB