Re: Need some help with dates

> Hi.
>
> First, let me apologize for my poor level in english, I hope you'll
> understand me.
>
> I'm new in PL/PgSQL, and I have a little problem.
>
> I have a temporary table (temp) with only varchar. I must do a request
> that fill another table (mclis) with temp's data. But on the new
> tables, I have a field in date format. When I make a
>
> update mclis
> set cli_date = temp.temp1
>
> he doesn't want because of the different formats ('column "cli_date" is
> of type 'date' but expression is of type 'character varying').
>
> In temp, my data are like 01/01/2001
>

Convert your date from varchar to date, using the to_date function.
ex:

to_date('05 Dec 2000', 'DD Mon YYYY')

Take a look at the formating functions available in Postgresql:
http://www.postgresql.org/idocs/index.php?functions-formatting.html


Regards
Miguel Carvalho