psycopg2 / psycopg2.DataError: invalid input syntax for type timestamp with time zone:

[D'Arcy J.M. Cain]

On Tue, 30 Mar 2010 15:46:12 -0700 (PDT)
ASh <anton.shishkov at gmail.com> wrote:
> > >             new_start_date = "NOW() - '29 days'::INTERVAL"
> > >             self.dyndb.orderdb.query('''update xxxx set creation_date
> > > = %s
> > >             where id_order = %s''', (new_start_date, "123"))
> >
> > Put single quotes around the first %s in the query.
> 
> Tried like you said, got this error:
> 
> psycopg2.ProgrammingError: syntax error at or near "NOW"
> LINE 1: update orderdb.orders set creation_date = 'E'NOW() - ''29
> da...

Right.  I misread it.  Please show us the exact error that you get with
the original code.

-- 
D'Arcy J.M. Cain <darcy at druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.