[GLLUG] PHP help

[Basher584]

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

select bla from table where TO_DAYS(NOW()) - TO_DAYS(datefield) >=30;

-Ben

On Fri, Jul 19, 2002 at 03:54:42PM -0400, Adam Kendall wrote:
> Ok, I've got a list of dates stored in a MySQL database in the following
> format:
> mm-dd-yyyy
> 
> I want to be able to check if these dates are more than 30 days older than
> today.
> Is there an easy way to do this?  ...or does someone have a function already
> written to do a similar task that they might be willing to share?  I would
> really appreciate it!  Thank you in advance!
> 
> -Adam Kendall
> 
> 
> _______________________________________________
> linux-user mailing list
> linux-user@egr.msu.edu
> http://www.egr.msu.edu/mailman/listinfo/linux-user