Re: Fwd: Timestamp Query Parameters

On Thu, 13 Mar 2014 17:40:52 -0400
Ari King <ari(dot)brandeis(dot)king(at)gmail(dot)com> wrote:

> 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)

Found this in the doc:
http://initd.org/psycopg/docs/usage.html#index-9

Looks like you can use Python Date/time objects directly.

Regards

--
Lutz Steinborn
4c Business Service GmbH
Putzbrunner Str. 71
81739 Muenchen

l(dot)steinborn(at)4c-ag(dot)de, http://www.4c-gmbh.de

---------------------------------------------------------
Sitz der Gesellschaft: Putzbrunner Str. 71, 81739 Muenchen
Vertretungsberechtigter Geschaeftsfuehrer: Frank W. Lutze
Registergericht: Amtsgericht Muenchen
Registernummer: HR 130 207
Ustnr. gemaess § 27 a Umsatzsteuergesetz: DE 206 864 106