Re: Need some help with dates

Hi Stéphane,

to_number works in the same fashion as in oracle. You need to give
to_number('<yourdata>','formatmask')
For example, to_number('1234567','FM9999999')

Regards,
Gautham.

----- Original Message -----
From: "Stéphane DEWITTE" <stephane(at)smeso(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
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(dot)rao(at)tatainfotech(dot)com]
> > Envoyé : mercredi 17 avril 2002 15:00
> > À : Stéphane DEWITTE; pgsql-sql(at)postgresql(dot)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" <stephane(at)smeso(dot)fr>
> > To: <pgsql-sql(at)postgresql(dot)org>
> > 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
>