Am I filtering by date correctly?

Question

Yii

Good afternoon!
It is necessary in Yii2 to display records for which the publication date ends later than today's date.
I did it in the controller like this:

$posts = $query->where(['>', 'date_end', date('Y-m-d')])
        	->offset($pagination->offset)
        	->limit($pagination->limit)
        	->all();

Will it be correct? After all, in this case we are comparing two text values? Or is there another better way?
Thank you!

Answer 1

Store a DATETIME or Unix TimeStamp in the database. In your case, as I understand it, you have varChar - make an index on this field in the database, it will be faster.