How to select a record (outdated) in SQL where today's date is higher than the creation date?

Question

MySQL

There is, for example, the date of creation of the entry, in the variable $data='09/05/2015'.
And there is today's date: 08/09/2015
How to select a record from the database where the record creation date is older than today's date (or vice versa)?
I tried this, it doesn’t work (I know that I need to convert the date and process it, but I don’t know):

SELECT * FROM table WHERE table.date > '09.08.2015';

Answer 1

www.techonthenet.com/mysql/functions/str_to_date.php
www.w3schools.com/sql/func_curdate.asp

Answer 2

This query will use indexes. Time to store in timestamp.

SELECT * FROM table WHERE DATE(table.date) > STR_TO_DATE('2015-08-09', '%Y-%m-%d');

Answer 3

Make a date in UnixTime, or make your own reporting system, let's say the number of days after 01/01/2015.
Maybe fit in 2 bytes)