Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MongoDB ObjectId().getTimestamp

Is there a way to extract the datetime from a Mongo ObjectId?
I'm connecting with tMongoDBInput and want to output to tFileOutputDelimited. Any ideas would be greatly appreciated.
Thanks,
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Is there a way to extract the datetime from a Mongo ObjectId?
I'm connecting with tMongoDBInput and want to output to tFileOutputDelimited. Any ideas would be greatly appreciated.
Thanks,

http://docs.mongodb.org/manual/reference/object-id/
Don't know if Talend provides a feature for that. Else you might write own Java code to get the first four byte of the ID and pasre it to Unix Epoch Seconds...