In the PostgreSQL database, the table has a published field (timestamp with timezone).

How can Python (py-postgresql) select entries that have been published on a given date? (Let timezone and date be explicit).

You need something like:

select = database.prepare( "SELECT id, link, title, summary, content, published " "FROM records " "WHERE published::date = $1::date" ) … date = dateutil.parser.parse(input()) records = select(date)

    1 answer 1

     SQL="SELECT * FROM records WHERE published::date = {}::date".format($1) rv = plpy.execute(SQL)