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

Anton Shishkov <[email protected]> Wed, 31 Mar 2010 01:53:09 +0300

Newsgroups	gmane.comp.python.db.psycopg.devel
Message-ID	<[email protected]>

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"))

...
psycopg2.DataError: invalid input syntax for type timestamp with time
zone: "NOW() - '29 days'::INTERVAL"

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg