尝试一下

SELECT DATE_FORMAT(PictureModifiedDateTime,'%y-%m-%d') AS FILE_DATE WHERE column = "blah"

或使用日期

SELECT DATE(PictureModifiedDateTime) AS FILE_DATE WHERE column = "blah"