Re: converting varchar date strings to date

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