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