Comparing datatime field with current time and time in MySQL

Question

I have something like this:

to_days(now()) < to_days(birth) 

This works, but instead of comparing the days, I also had to compare the time. Is there a similar feature?

Answer 1

Why don't you just use:

 birth > NOW() 

Answer 2

Are you looking for the DAYOFYEAR () function? http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dayofyear