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?
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com>http://www.umpa-us.com
1-800-555-9665 ext 212