正如MySQL Using a string column with date text as a date field岁时所说的,你可以做到
SELECT STR_TO_DATE(yourdatefield, '%m/%d/%Y')
FROM yourtable
您还可以在WHERE
个子句中处理这些日期字符串.例如
SELECT whatever
FROM yourtable
WHERE STR_TO_DATE(yourdatefield, '%m/%d/%Y') > CURDATE() - INTERVAL 7 DAY
您可以通过这种方式处理各种日期/时间布局.请参考the format specifiers for the DATE_FORMAT()
function,看看你能在STR_TO_DATE()
的第二个参数中输入什么.