Why am I getting an error if I am trying to modify data type?
In your image you have far to many parenthesis
ALTER TABLE store MODIFY DOB char(40);

The parenthesis you put around column name and type is not valid.