How To Compare A Longtext And Date Value In Sql?

I have date value stored in format dd.mm.yyyy as longtext. I need to compare this value to CURDATE() within a SELECT statement. (Please, don't ask me why it is saved in longtext.)

Solution 1:

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

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