in reply to Re: DBI quoting when I don't want it to
in thread DBI quoting when I don't want it to

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')
  • Comment on Re: Re: DBI quoting when I don't want it to

Replies are listed 'Best First'.
Re: Re: Re: DBI quoting when I don't want it to
by Mur (Pilgrim) on Aug 21, 2002 at 18:46 UTC 
    
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]

In Section Seekers of Perl Wisdom