Convert Date String to Long in MongoDB

Question

There are some basic conversions questions already.

As I'm new to MongoDB, need help for this specific conversion:

Last modification date is being saved as String("last_modification" : "/Date(1520430205000)/") data type in my document. I have to get only numeric(1520430205000) value from the field and convert it to long as well.

After conversion, the last modification value should be 1520430205000 as long data type.

mickl · Accepted Answer · 2019-06-10 14:11:05Z

1

You can use $trim to remove all the characters that are not representing digits and then run $toLong operator. Both operators are available in MongoDB 4.0 or newer. Try:

db.collection.aggregate([
    {
        $addFields: {
            last_modification: {
                $trim: {
                    input: "$last_modification",
                    chars: "/Date()"
                }
            }
        }
    },
    {
        $addFields: {
            last_modification: {
                $toLong: "$last_modification"
            }
        }
    },
    { $out: "collection" }
])

MongoDB Playground

EDIT: You can use $out to modify existing collection

edited Jun 10, 2019 at 14:11

answered Jun 10, 2019 at 6:08

mickl

50.1k9 gold badges71 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Devkinandan Chauhan Over a year ago

Thanks mickl, it worked. but it did not update the value in the collection. Could you please help for updating the value in the collection as well?

mickl Over a year ago

@DevkinandanChauhan modified my answer

Collectives™ on Stack Overflow

Convert Date String to Long in MongoDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related