Not sure about PostGres or Oracle, but using MySQL you can leave out the '+' sign and replace with a comma:
(NOW(), INTERVAL 1 MONTH)
I'd also look at the DATE_FORMAT which is a handy little tool:
DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 MONTH), '%Y-%m-%d')
| [reply] |
Postgres won't allow
... interval 1 month ...
Instead, it must be
... interval '1 month' ...
--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt...Connecting People With Expertise
| [reply] |