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

ASh anton.shishkov at gmail.com
Tue Mar 30 16:47:42 EDT 2010


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"





More information about the Python-list mailing list