At 04:23 PM 4/8/2004, Mike Nolan wrote:
> I need a query to get data that is 6 months older than "today" or when that
> query is run.
WHERE table.date < current_date-interval'6 months'
--
Mike Nolan
| Brian C. Doyle | ||
| Director, Internet Services | ||
| United Merchant Processing Association | ||
| http://www.umpa-us.com | ||
| 1-800-555-9665 ext 212 |
