正如 Sergey 所说:如果是 MySQL，你可以简单地使用 STR_TO_DATE:

As Sergey comments: if MySQL, you can simply use STR_TO_DATE:

    ...
WHERE STR_TO_DATE(longtext_date_value,'%d.%m.%Y') <= CURDATE()
    ...