str to date - update with separate month/year

[thompom]

Hi,

In a table i have [stupidly] stored a date in separate month and year field, now i want to merge those fields and put them in a date field

have tried the following which puts the year in the date field - but how do i add the month aswell
[the day should be set to 01]

update table set dateadd = str_to_date(yearadd,'%Y')

thanks MG

 

[johnwm]

I think you need to concatenate the separate parts. If you use concat_ws it automatically adds the separator.:
select str_to_date(concat_ws('/',2008,04,01),'%Y/%m/%d')

Have a look at

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

and

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_concat-ws

for details.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[thompom]

thanks for the idea john - concat got the jobdone

UPDATE table SET datenew = CONCAT(year, month, '01');