Query by dates to find history records

[JMay0816]

what is the correct way to query on a date field in a table to pull a value that is older than 3 days?

Date field format is 2007-04-04

I only want records where the date is 2007-04-01 or earlier.

thx

 

[johnwm]

To select stuff more than 3 days old use curdate() to return the current date then use the Interval function for your offset :

SELECT *
FROM mytable
WHERE mydatefield > ( curdate( ) - INTERVAL 3 DAY )

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[guelphdad]

John, you want < and not > your query will return records from three days ago and newer. The OP wanted items from three days ago and older.

Yours will return records from 2007-04-12 but they want records from 2007-03-29 for instance.

 

[johnwm]

Thanks guelphdad - excuse my thick finger syndrome!

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[guelphdad]

I've done it myself!