book
Article ID: KB0081954
calendar_today
Updated On:
Description
MongoDB Data: JSON object
{"_id":{"$oid":"59cd182054cbe615617b83b0"},"address":{"building":"1007","coord":[-73.856077,40.848447],"street":"Morris Park Ave","zipcode":"10462"},"borough":"Bronx","cuisine":"Bakery","grades":[{"date":{"$date":"2014-03-03T00:00:00.000Z"},"grade":"A","score":2},{"date":{"$date":"2013-09-11T00:00:00.000Z"},"grade":"A","score":6},{"date":{"$date":"2013-01-24T00:00:00.000Z"},"grade":"A","score":10},{"date":{"$date":"2011-11-23T00:00:00.000Z"},"grade":"A","score":9},{"date":{"$date":"2011-03-10T00:00:00.000Z"},"grade":"B","score":14}],"name":"Morris Park Bake Shop","restaurant_id":"30075445"}
CIS will parse and show date in UTC format
date = 2011-11-23T00:00:00.000Z
It will prevent if we want to do any numerical operation
Issue/Introduction
This KB article will help you in serializing mongodb date in TDV
Resolution
We implemented a config option to serialize date time values as Unix Timestamps to conform to the 2016 version of the driver.
To obtain this functionality you can add “SerializeDateTimeAsUnixTS=True” to the “Other” property.