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 [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
