perl mongDB to_json howto convert an ISODate, What is the right way to serialize Datetime object

Question

I have a mongoDB with :

my $data = $newspapers->find_one({_id => 2000});

last_mdb_update is a datetime in $data and is a ISODate in mongoDB

$result = to_json( $data, { ascii => 1, utf8 => 1, pretty => 1 } );

I got an error: encountered object '2013-11-06T06:45:16', but neither allow_blessed nor convert_blessed settings are enabled

Note: I can do, to fix and serialize, but is an ugly workaround and just works for that field:

$data->{last_mdb_update} = ''.$data->{last_mdb_update};

$result = to_json( $data, {ascii => 1, utf8 => 1, pretty => 1, convert_blessed => 1 } ); says (...) nor TO_JSON method available

what is TO_JSON method for ISODate ?

score 1 · Answer 1 · answered Nov 06 '13 at 07:34

1

By default, MongoDB ISODate objects are returned as DateTime objects in the Perl MongoDB driver. The error you are getting sounds like it is coming from the JSON serialization library, which is unrelated to MongoDB.

JSON has no native datetime type, so if you want to serialize it you'll need to convert the DateTime object to some kind of number or string first.

answered Nov 06 '13 at 07:34

friedo

65,762
16
114
184

we need todo TO_JSON method for Object ISODate – Sérgio Nov 06 '13 at 07:41

Sérgio · Answer 2 · 2013-11-07T00:04:44.317

0

sub DateTime::TO_JSON {
    { "".shift }
}

my $result = to_json( $data, { utf8 => 1, pretty => 1, convert_blessed => 1 } );

works !

edited Nov 07 '13 at 00:04

answered Nov 06 '13 at 20:58

Sérgio

6,966
1
48
53

perl mongDB to_json howto convert an ISODate, What is the right way to serialize Datetime object

2 Answers2