Subject | Subtract from date, Now |
---|---|
Author | William L. Thomson Jr. |
Post date | 2004-11-10T14:55:24Z |
I need to run a query including the last 30 days. I am thinking
something along the lines of
SELECT * FROM TABLE WHERE COLUMN<='NOW'-30;
But I know the above does not work
Any ideas or suggestions
--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.
http://www.obsidian-studios.com
something along the lines of
SELECT * FROM TABLE WHERE COLUMN<='NOW'-30;
But I know the above does not work
Any ideas or suggestions
--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.
http://www.obsidian-studios.com