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