[thelist] comparing dates in mysql

rudy thelist at lists.evolt.org
Mon Feb 24 09:31:01 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