Re: converting varchar date strings to date - Mailing list pgsql-general

Hello,

This has been resolved.
As I told a previous poster, CAST() wasn't working.
I have no idea why.

I finally used:

UPDATE inventory SET date_field=date(vc_year||'-'||vc_month||'-'||vc_day );

Peter


> pw writes:
>
> > How can I typecast a date generated from VARCHAR fields into
> > a date field
>
> Using CAST().
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>