converting varchar date strings to date

On Tuesday 14 October 2003 17:54, pw wrote:

Hello,

How can I typecast a date generated from VARCHAR fields into
a date field

ie:

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

... SET date_field = CAST(vc_year...vc_day AS date)
or
... SET date_field = (vc_year...vc_day)::date

The first is SQL-standard, the second less typing.

If that gives you problems, cast to text first, then to date.

--
Richard Huxton
Archonet Ltd

pw writes:

How can I typecast a date generated from VARCHAR fields into
a date field

Using CAST().

--
Peter Eisentraut peter_e@gmx.net

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