https://community.qlik.com/t5/Talend-Studio/MongoDB-ObjectId-getTimestamp/m-p/2218822#M13869 Is there a way to extract the datetime from a Mongo ObjectId? <BR />I'm connecting with tMongoDBInput and want to output to tFileOutputDelimited. Any ideas would be greatly appreciated. <BR />Thanks, Sat, 16 Nov 2024 11:43:55 GMT Anonymous 2024-11-16T11:43:55Z https://community.qlik.com/t5/Talend-Studio/MongoDB-ObjectId-getTimestamp/m-p/2218822#M13869 Is there a way to extract the datetime from a Mongo ObjectId? <BR />I'm connecting with tMongoDBInput and want to output to tFileOutputDelimited. Any ideas would be greatly appreciated. <BR />Thanks, Sat, 16 Nov 2024 11:43:55 GMT https://community.qlik.com/t5/Talend-Studio/MongoDB-ObjectId-getTimestamp/m-p/2218822#M13869 Anonymous 2024-11-16T11:43:55Z https://community.qlik.com/t5/Talend-Studio/MongoDB-ObjectId-getTimestamp/m-p/2218823#M13870 <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Is there a way to extract the datetime from a Mongo ObjectId?<BR />I'm connecting with tMongoDBInput and want to output to tFileOutputDelimited. Any ideas would be greatly appreciated.<BR />Thanks,</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR /> <A href="http://docs.mongodb.org/manual/reference/object-id/" rel="nofollow noopener noreferrer">http://docs.mongodb.org/manual/reference/object-id/</A> <BR />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... Tue, 04 Mar 2014 16:32:00 GMT https://community.qlik.com/t5/Talend-Studio/MongoDB-ObjectId-getTimestamp/m-p/2218823#M13870 Anonymous 2014-03-04T16:32:00Z