Change DATETIME to DATE

in phpmyadmin

[tonynoriega]

can i change a data type from DATETIME to DATE in myphpadmin?

i basically want to just drop the HH:MM:SS from the datetime column ...

if i do, will i retain the values that are in there already?

[venelin13]

You can do it with no problems, no data will be lost. The dates will be formated automaticaly to YYYY-MM-DD