Hello all,
I am rather confident that this has been answered in the past but
searching for it has been a pain so I am asking for some
assistance.
I need a query to get data that is 6 months older than
"today" or when that query is run.
So the where clause is something like
WHERE table.date >= now() - 6 months
I know that will not work so how should I do this?
| Brian C. Doyle | ||
| Director, Internet Services | ||
| United Merchant Processing Association | ||
| http://www.umpa-us.com | ||
| 1-800-555-9665 ext 212 |
