KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a MySQL query like: SELECT mydate, countryCode, qtySold from sales order mydate, countryCode This returns tuples of tuples with values like: ((datetime.date(2011, 1, 3), 'PR', Decimal('1')), (datetime.date(2011, 1, 31), 'MX', Decimal('1'))) When I try printing this using a loop, it prints perfectly fine: 2011-1-3, PR, 1 2011-1-31, MX, 1 But when I try to return this value, it returns as datetime.date(2011, 1, 3), 'PR', Decimal('1') Is there a way that I can get normal data so that I can pass it to UI for processing? By normal data I mean: [['2011-1-03', 'PR', 1], ...]
Tags (comma-separated)
Save Edits
Cancel