X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 070AF9DCAA6 for ; Thu, 8 Dec 2005 03:12:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56456-09 for ; Thu, 8 Dec 2005 03:12:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id C003F9DCA95 for ; Thu, 8 Dec 2005 03:12:08 -0400 (AST) Received: from webmail-outgoing.us4.outblaze.com (webmail-outgoing2.us4.outblaze.com [205.158.62.67]) by svr2.postgresql.org (Postfix) with ESMTP id DDC80F0B33 for ; Thu, 8 Dec 2005 07:12:08 +0000 (GMT) Received: from unknown (unknown [192.168.9.180]) by webmail-outgoing.us4.outblaze.com (Postfix) with QMQP id 4EFFC1800208 for ; Thu, 8 Dec 2005 07:12:07 +0000 (GMT) X-OB-Received: from unknown (208.36.123.33) by wfilter.us4.outblaze.com; 8 Dec 2005 07:12:07 -0000 Received: by ws7-4.us4.outblaze.com (Postfix, from userid 1001) id 43903CA07E; Thu, 8 Dec 2005 07:12:07 +0000 (GMT) Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 From: "Noel Doydora" To: pgsql-sql@postgresql.org Date: Thu, 08 Dec 2005 15:12:07 +0800 Subject: cannot alter column data type to "date" Received: from [203.177.75.32] by ws7-4.us4.outblaze.com with http for uwq291@lycos.com; Thu, 08 Dec 2005 15:12:07 +0800 X-Originating-Ip: 203.177.75.32 X-Originating-Server: ws7-4.us4.outblaze.com Message-Id: <20051208071207.43903CA07E@ws7-4.us4.outblaze.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.651 required=5 tests=[DNS_FROM_RFC_POST=1.44, DNS_FROM_RFC_WHOIS=0.879, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 3.651 X-Spam-Level: *** X-Archive-Number: 200512/69 X-Sequence-Number: 23611 Below is the message I receive when I try to alter the data type of=20 a column to "date". I had to drop the column and add it again just=20 so I can set its data type to "date". How do I change a column's=20 data type to "date" without dropping and then creating it again? Hoping for a kind response. Thank you. SQL error: ERROR: column "date_signed" cannot be cast to type "date" In statement: ALTER TABLE "canvass" ALTER COLUMN "date_signed" TYPE date --=20 _______________________________________________ Search for businesses by name, location, or phone number. -Lycos Yellow Pa= ges http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as= p?SRC=3Dlycos10