> -----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" <stephane@smeso.fr>
> To: <pgsql-sql@postgresql.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.