Received: from apache.smeso.fr (unknown [212.234.3.50]) by postgresql.org (Postfix) with ESMTP id 511584760F9 for ; Wed, 17 Apr 2002 09:33:55 -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 PAA21813; Wed, 17 Apr 2002 15:33:53 +0200 From: =?iso-8859-1?Q?St=E9phane_DEWITTE?= To: "Gautham S. Rao" , Subject: Re: Need some help with dates Date: Wed, 17 Apr 2002 15:33:15 +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: <014201c1e616$abe40140$41057aa3@tatainfotech.com> Importance: Normal X-Archive-Number: 200204/211 X-Sequence-Number: 7475 > 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. Thanks a lot ! That works !!