Received: from txino.mikasa.eh (42-ZARA-X27.libre.retevision.es [62.82.240.42]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16IV7x24703 for ; Tue, 6 Feb 2001 13:31:07 -0500 (EST) (envelope-from txino@wanadoo.es) Received: by txino.mikasa.eh (Postfix, from userid 502) id 94B7675BEB; Tue, 6 Feb 2001 19:20:57 +0100 (CET) From: "J.Fernando Moyano" Date: Tue, 6 Feb 2001 19:20:57 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: pgsql-sql@postgresql.org Subject: type casting: varchar to date MIME-Version: 1.0 Message-Id: <01020619205704.01568@txino.mikasa.eh> Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/91 X-Sequence-Number: 1269 Is there some way to do something like this ?? : crate table t ( a varchar(12), b date ); select (a::date-b) from t; ERROR: cannot cast type 'varchar' to 'date'. Thanks .... -- Fer