[thelist] comparing dates in mysql

rudy r937 at interlog.com
Mon Feb 24 09:31:01 CST 2003


>   ...   where to_days(dateCreated)>30

the to_days function converts a date to the number of days since year 0

what you want is

    where  to_days(current_date) - to_days(dateCreated) > 30

rudy



More information about the thelist mailing list