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
>
>