Formatting SQL query output in Python/SQLite 3

Question

I use a simple SQL query in Python to grab records from a SQLite 3 database:

cursor.execute ("SELECT due, task FROM tasks WHERE due <> '' ORDER BY due ASC")
        rows = cursor.fetchall()
            for row in rows:
                print '\n%s %s' % (row[0], row[1])

The due field in the database is set to DATE type, so the query returns the data in this field formatted as 2010-07-20 00:00:00.00 How can I remove the 00:00:00.00, so the result contains only the date? Thanks!

SiggyF · Accepted Answer · 2010-07-20 11:19:00Z

3

I think row[0] is a datetime object. So the following should work:

print '\n%s %s' % (row[0].strftime('%Y-%m-%d'), row[1])

answered Jul 20, 2010 at 11:19

SiggyF

23.3k8 gold badges46 silver badges57 bronze badges

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

1 Comment

Nick Dandoulakis Over a year ago

you could also write the query like SELECT strftime('%Y-%m-%d', due), ...

Collectives™ on Stack Overflow

Formatting SQL query output in Python/SQLite 3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related