Getting error while running SQL query near "HOUR"

Question

query1:

SELECT count(*) 
from covips.pool_checkup 
WHERE timeinstance > DATE_ADD(NOW(), INTERVAL -1 HOUR)

cursor.execute(query1)
count2 = cursor.fetchone()[0]
print("test ", count2)

ERROR I AM GETTING IS

Error while connecting to PostgreSQL syntax error at or near "HOUR" LINE 2: ...p

WHERE timeinstance > DATE_ADD(NOW(), INTERVAL -1 HOUR)

Plz read the basis of postgres documentation : postgresql.org/docs/9.1/functions-datetime.html — Olivier Depriester
– Olivier Depriester, Commented Aug 15, 2020 at 8:54

forpas · Accepted Answer · 2020-08-15 08:56:50Z

1

Your query uses MySql syntax for a Postgresql database where there is no DATE_ADD() function.
This is the correct syntax:

WHERE timeinstance > NOW() - INTERVAL '1 hour'

answered Aug 15, 2020 at 8:56

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.