multiple columns value into date string

[thefisherman]

Hi!

I've got something here:

I have a table (MySQL) which holds the date in three columns:

1 - day CHAR(2)
2 - month CHAR(2)
3 - year VARCHAR(4)

as well as other data.

I would like to take the contents of the three columns and convert it/copy it into one DATE column which is then much easier to use.

It's roughly 450 dates in that table, would be nice to be able to do it with a WHILE loop or something like that.

I figured out the whole WHILE thing but can't get the date format right to write back to the new DATE column i added.

Any help much appreciated!

Regards

[leatherback]

hm.. I think I would try something like this:

update TABLE set date= concat(year, '-', month, '-', day)

Not sure whether this works, so try on a duplicate first