MongoDB UTC Date Formatting

MongoDB UTC Date Formatting

book

Article ID: KB0081954

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6

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.