import psycopg2
import time

connection = "host='10.2.8.85' dbname='basedados' user='postgres' password='wilci5w7'"
#connection = "host='localhost' dbname='basedados' user='postgres' password='wilci5w7'"

conn = psycopg2.connect(connection )

PARAMETRO_DATA = 840

date_format = "%Y-%m-%dT%H:%M:%S"

sql = """
SELECT 	monitor_medicao."vlrLbl",
	    monitor_medicao."Campanha_FK_id",
	    monitor_medicao."PtoMonit_FK_id"
FROM 	monitor_medicao
WHERE 	monitor_medicao."Parametro_FK_id" = %s;
"""


sql_update = """
UPDATE  monitor_medicao
SET     data = to_timestamp(%s)
WHERE 	monitor_medicao."Campanha_FK_id" = %s AND
	    monitor_medicao."PtoMonit_FK_id" = %s;
"""



cursor = conn.cursor()
cursor.execute(sql, [PARAMETRO_DATA,])

for row in cursor.fetchall():
    date_full = row[0]

    date_fmt = date_full[:19]
    ttuple = time.strptime(date_fmt, '%Y-%m-%dT%H:%M:%S')
    timestamp = time.mktime(ttuple)
    print(timestamp)

    parametros = [ timestamp, row[1], row[2]]

    cursor_update = conn.cursor()
    cursor_update.execute(sql_update, parametros)
    rowcount = cursor_update.rowcount


conn.commit()
conn.close()