date format?

[php_begins]

I have a date field in the database table of this format 2012-02-08.

Now I want to select fields from the database where date >= $currentdate.

Do I have to do someting like

$currentdate=time();

//Then convert it into YYYY-MM-DD format?

[Pikachu2000]

SELECT fields FROM table WHERE date >= CURDATE()

 

MySQL has a bunch of native date/time functions HERE.