How to get mongodb sysdate in talend using mongodb connector
I have talend and mongodb on two different servers and two different zones ( these timezones may change in future). I am trying to set context variable in taled to mongodb sysdate. I have tried few ways using tMongodbInput and tMongodbRow with new Date(), new ISODate() and $currentDate methods. But it is either a JSON parse exception or Bad Command. I am looking for mongodb query for select sysdate from dual. Is there any way to get sysdate like this in taled using mongodb
Thank you for suggestion. As mentioned in my question description i have tried these two methods, but it is throwing an exception. I appreciate if you can share any screenshot if you have tried/implemented.
