Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Date round in mongo db query component

I have a date field in utc format like '2017-06-02 16:39:35.843' how to round the date '2017-06-02 16:39:36' in mongodb query component advanced mode?

1 Community Answers

Matillion Agent  

David Lipowitz —

Hi Ganesh,

Thanks for the question. Is it possible to transform this data after you load it into the data warehouse instead of during the extraction from Mongo?

I believe the date/time functions at your disposal in the warehouse (Redshift, Snowflake, of BigQuery) will be easier to work with than transforming the data in flight from mongo.

Best Regards,
Dave

Post Your Community Answer

To add an answer please login