Received: from apache.smeso.fr (unknown [212.234.3.50]) by postgresql.org (Postfix) with ESMTP id 846E847587E for ; Wed, 17 Apr 2002 08:33:41 -0400 (EDT) Received: from STEPHFIXE (ocp.smeso.fr [192.168.168.35]) by apache.smeso.fr (8.9.3/8.9.3) with SMTP id OAA13972 for ; Wed, 17 Apr 2002 14:33:44 +0200 From: =?iso-8859-1?Q?St=E9phane_DEWITTE?= To: Subject: Need some help with dates Date: Wed, 17 Apr 2002 14:33:05 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200204/205 X-Sequence-Number: 7469 Hi. First, let me apologize for my poor level in english, I hope you'll understand me. I'm new in PL/PgSQL, and I have a little problem. I have a temporary table (temp) with only varchar. I must do a request that fill another table (mclis) with temp's data. But on the new tables, I have a field in date format. When I make a update mclis set cli_date = temp.temp1 he doesn't want because of the different formats ('column "cli_date" is of type 'date' but expression is of type 'character varying'). In temp, my data are like 01/01/2001 I tried also set cli_date = select case(temp.temp1 as date) but he says: Cannot cast type 'character' to 'date' or Cannot cast type 'character varying' to 'date'. Does anyone has an idea ?