[thelist] comparing dates in mysql

RUST Randal RRust at COVANSYS.com
Mon Feb 24 09:22:00 CST 2003

I need some sql to run that will compare allow me to see if a record is
more than 30 days old. Is the following appropriate?

select * from $table where to_days(dateCreated)>30

Randal Rust
Covansys Corp.
Columbus, OH

More information about the thelist mailing list