Fwd: Timestamp Query Parameters

Поиск
Список
Период
Сортировка
От Ari King
Тема Fwd: Timestamp Query Parameters
Дата
Msg-id CAPcS2agNgwVLNDgw0qVbsVzixSTpMKDFL3uLH557CdWJqX1dWA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Fwd: Timestamp Query Parameters
Re: Fwd: Timestamp Query Parameters
Список psycopg
Hi,

I'm just starting out with psycopg2. I'm trying to pass a timestamp query parameter to an sql query. Unfortunately the constructed query returns nothing, even though it should. The code follows; does anyone see what I'm doing wrong?

date = datetime.now().strftime("%Y-%m-%d")
params = [datetime.strptime(date + " 00:00:00", '%Y-%m-%d %H:%M:%S'), datetime.s
trptime(date + " 23:59:59", '%Y-%m-%d %H:%M:%S')]
print params
try:
  query = """select * from timesheet
s where submitted=true and started_at between '%s' and '%s'"""
  cursor.mogrify(query, params)

Thanks.

-Ari

В списке psycopg по дате отправления: