updating the year using informix sql 1

[ejaggers]

update table set column[7,10] = "2009";

works if column is a string datatype, but how can i change only the year if column is datatype date, using informix SQL?

 

[PHV]

UPDATE table SET column=MDY(MONTH(column),DAY(column),2009);

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886