Dates in PHP with MySQL

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

a_gajic posted this at 13:19 — 26th January 2002.

They have: 66 posts

Joined: Aug 2001

Hey guys,

I was wondering and I can't seem to find the way how to do this but it has to be done!

I am running a mysql table (called hunters) in hunters there is a date of a submission (timestamp, yyyymmddhhmmss).

I only want the script to pull out dates from the database that are no more that 30 days old.

How can I do this?

Thanks,
Adam.

Mark Hensler posted this at 17:31 — 26th January 2002.

Joined: Aug 2000

SELECT * FROM table_name WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) > 30

Mark Hensler ["Max Albert"] [Email]
If there is no answer on Google, then there is no question.