Received: from itplrelay.in.tatainfotech.com (unknown [203.200.59.46]) by postgresql.org (Postfix) with ESMTP id 1E6F447587E for ; Wed, 17 Apr 2002 09:31:46 -0400 (EDT) Received: from blrmail.in.tatainfotech.com (IDENT:root@itplrelay.tatainfotech.com [127.0.0.1]) by itplrelay.in.tatainfotech.com (8.11.0/8.11.0) with ESMTP id g3HDXLF15592; Wed, 17 Apr 2002 19:03:22 +0530 Received: from dsspntw34 ([163.122.5.65]) by blrmail.in.tatainfotech.com (8.9.3/8.9.3) with SMTP id TAA22356; Wed, 17 Apr 2002 19:04:31 +0530 Message-ID: <014201c1e616$abe40140$41057aa3@tatainfotech.com> From: "Gautham S. Rao" To: =?iso-8859-1?Q?St=E9phane_DEWITTE?= , References: Subject: Re: Need some help with dates Date: Wed, 17 Apr 2002 19:19:18 +0530 Organization: Tata Infotech Ltd. MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/210 X-Sequence-Number: 7474 Hi Stéphane, to_number works in the same fashion as in oracle. You need to give to_number('','formatmask') For example, to_number('1234567','FM9999999') Regards, Gautham. ----- Original Message ----- From: "Stéphane DEWITTE" To: Sent: Wednesday, April 17, 2002 6:31 PM Subject: Re: [SQL] Need some help with dates > > > > -----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. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >