Extracting DATE from '2008-05-17 11:31:31' using MySQL:

Required DATE
2008-05-17