I have something like that:
to_days(now()) < to_days(birth)
It work but instead of comparing days I was to compare the time too. Is there a similar function?
views:
27answers:
2
A:
Are you looking for DAYOFYEAR() function ? http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dayofyear
a1ex07
2010-04-13 17:14:48
+1 and use an index!
KM
2010-04-13 17:26:29
Because I need to subtract 15 days to the death field, than compare it:birth <= now( ) AND now( ) < (death - 15)
rtacconi
2010-04-14 17:56:07
Your answer is correct. I want to add the to modify a date and compare it is easy: (birth + INTERVAL 15 DAY) > NOW()I add 15 days to birth and compare if is equal to current date and time.
rtacconi
2010-04-16 16:30:17