Ask Your Question

Load datetime into MongoDB

asked 2018-12-27 13:54:06 -0500

srinath_222 gravatar image


I am trying to load the datetime value from a relational origin into MongoDB destination.

I have the data coming from origin as below: create_dt:{DATETIME} Mar 14, 2018 6:41:38 PM

If I load into MongoDB destination directly without using any processors, it is loading as EPOCH date (If I convert data type to string, the data is in date format (YYYY-MM-DD HH:mm:SS) but the type will be String).

I need the data in MongoDB with format YYYY-MM-DD HH:mm:SS and with type as DATETIME.

Please suggest me an approach how to convert the date time value.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-12-27 20:34:15 -0500

iamontheinet gravatar image


There are a couple of open issues related to this that you can watch and vote on -- and

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-27 13:54:06 -0500

Seen: 560 times

Last updated: Dec 27 '18