Received: from apache.smeso.fr (unknown [212.234.3.50]) by postgresql.org (Postfix) with ESMTP id 1755047631C for ; Wed, 17 Apr 2002 09:01:57 -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 PAA16984 for ; Wed, 17 Apr 2002 15:02:00 +0200 From: =?iso-8859-1?Q?St=E9phane_DEWITTE?= To: Subject: Re: Need some help with dates Date: Wed, 17 Apr 2002 15:01:21 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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 In-Reply-To: <012801c1e60f$cbd86920$41057aa3@tatainfotech.com> Importance: Normal X-Archive-Number: 200204/209 X-Sequence-Number: 7473 > -----Message d'origine----- > De : Gautham S. Rao [mailto:gautam.rao@tatainfotech.com] > Envoyé : mercredi 17 avril 2002 15:00 > À : Stéphane DEWITTE; pgsql-sql@postgresql.org > Objet : Re: [SQL] Need some help with dates > > > Hi Stéphane, > > Use, > update mclis > set cli_date = to_date(temp.temp1,'dd/mm/yyyy') > > Regards, > Gautham. > > ----- Original Message ----- > From: "Stéphane DEWITTE" > To: > Sent: Wednesday, April 17, 2002 6:03 PM > Subject: [SQL] Need some help with dates Thanks a lot. I knew it was existing in Orcale, but I haven't find any documentation on this function. I have another problem of that style, I must convert a varchar to a numeric. It seems that to_num or to_number doesn't exists, and cast tells me "Cannot cast type 'character varying' to 'numeric'". Does another function for that exists ? And where could I find a list of existing functions in Postgres 7.2 ? Regards, Stéphane.