DATE_ADD question regarding weird results

[lottos]

I have the following snippet of code.

When it runs on a an int(8) table record having data in the format of YYYYMMDD it changes the date to just YYYY.

Example:

20040210 becomes 2004

Any explanation and resolution of this?!

$db->query("update table_name set somedate = DATE_ADD(somedate, INTERVAL 4 DAYS ) WHERE somename like '$username'");

[TTT]

you have incorrect dateformat, don't use int, instead use date
correct date format is YYYY-MM-DD

[lottos]

oh no!

surely there is a way to add days to the date format I have used?