Results 1 to 12 of 12
Thread: Date older than xx days
Sep 19, 2012, 14:44 #1
- Join Date
- Aug 2004
- 0 Post(s)
- 0 Thread(s)
Date older than xx days
Trying to grab database records are older than 14 days.. In the database its stored as date/time.
I am wanting to check only on the date part of the field, so when the cron job runs through daily it only grabs records that are 14 days older than today.
I tried a few methods like:
WHERE DATE(timeslot) = DATE(NOW(), INTERVAL 14 DAY)