sqlalchemy: applying an SQL-like date() function on a datetime column

Question

I would like to group by date and count the resulting number of id's using sqlalchemy.

Unfortunately, my column containing date information created_datetime is a datetime and I would like to use an sql function like

group by date(created_datetime)

in order to group by date.

Here is what I have so far...

conn = engine.connect()

s = my_db.my_table.alias()

q = select([s.c.id]).\
    group_by(s.c.created_datetime).\
    count()

result = conn.execute(q)

for i in result:
    print(i)

conn.close()

van · Accepted Answer · 2014-04-01 04:17:45Z

12

Use sqlalchemy.sql.functions.func for this:

from sqlalchemy.sql import func

q = select([s.c.id]).\
    group_by(func.date(s.c.created_datetime)).\
    count()

answered Apr 1, 2014 at 4:17

van

77.6k13 gold badges174 silver badges179 bronze badges

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

Collectives™ on Stack Overflow

sqlalchemy: applying an SQL-like date() function on a datetime column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related