updating the year using informix sql 1

ejaggers · Dec 9, 2008

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 · Dec 9, 2008

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

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

updating the year using informix sql 1

ejaggers

Programmer

PHV

MIS

Similar threads

Part and Inventory Search

Sponsor