Ask Your Question
0

Load datetime into MongoDB

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

srinath_222 gravatar image

Hi,

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
1

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

iamontheinet gravatar image

Hi!

There are a couple of open issues related to this that you can watch and vote on -- https://issues.streamsets.com/browse/... and https://issues.streamsets.com/browse/...

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 252 times

Last updated: Dec 27 '18