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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
