Unable to serialize datetime.datetime object in dictionary to JSON using python and trac

Question

I have a list of dictionaries (each dictionary representing 1 record of an SQL query) which I am trying to serialize as JSON. There are several datetime.date and datetime.datetime objects in these dictionaries which are proving difficult to serialize. Initially, the error message is:

TypeError: datetime.date(2012, 5, 23) is not JSON serializable

After adding a handler to the json.dumps call the error message is:

TypeError: date_handler() takes exactly 1 argument (2 given)

date_handler looks like this:

    def date_handler(obj):
        return obj.isoformat() if hasattr(obj, 'isoformat') else obj

I'm running this as part of a Trac plugin however I think this is just an isolated python issue but have no idea what to do to sort it - does anyone have any ideas?

stackoverflow.com/questions/455580 could provide some more insight/options, at least for preliminary solutions. There are critical comments related to timezone support. — hasienda
– hasienda, Commented Jul 17, 2012 at 21:42

Gowri · Accepted Answer · 2014-08-21 08:49:42Z

2

I solved this by applying .isoformat() fields that were dates or timestamps in the dictionary as I'm importing the data from a database and so know what the field types are beforehand, thanks for your help!

edited Aug 21, 2014 at 8:49

Gowri

16.9k27 gold badges103 silver badges162 bronze badges

answered Jul 19, 2012 at 8:13

pwilding

331 silver badge6 bronze badges

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

Comments

hasienda · Accepted Answer · 2012-07-17 21:46:25Z

0

See a solution from the Django domain.

answered Jul 17, 2012 at 21:46

hasienda

2,3901 gold badge13 silver badges16 bronze badges

Collectives™ on Stack Overflow

Unable to serialize datetime.datetime object in dictionary to JSON using python and trac

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related