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

ASh anton.shishkov at gmail.com
Wed Mar 31 00:46:12 CEST 2010


On Mar 31, 12:50 am, "D'Arcy J.M. Cain" <da... at druid.net> wrote:
> On Tue, 30 Mar 2010 13:47:42 -0700 (PDT)
>
> ASh <anton.shish... at gmail.com> wrote:
> > Hi, please help me understand why am I getting error with this query
>
> >             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.
>
> --
> D'Arcy J.M. Cain <da... at druid.net>         |  Democracy is three wolveshttp://www.druid.net/darcy/               |  and a sheep voting on
> +1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

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...
                                                     ^



More information about the Python-list mailing list