Mongodb insert null date

Question

Mail Schema:

var mail = new mongoose.Schema({
    globalId: {type: String, index: true, unique: true},
    from: {type: String, required: true},
    beginDate: {type: Date, required: true},
    endDate: {type: Date},
    source: {type: String},
    address: {type: String},
    subject: {type: String, required: true},
    text: {type: String},
    note: {type: String},
    files: [
        {
            fileName: {type: String},
            fileSize: {type: Number},
            fileType: {type: String}
        }
    ]
});

When I try to save new mail with endDate is null I have the following error

Mail validation failed: endDate: Cast to Date failed for value "null"

save new mail with endDate as undefined

Ankit Agarwal
– Ankit Agarwal

2018-10-22 06:50:54 +00:00
Commented Oct 22, 2018 at 6:50 — Ankit Agarwal
– Ankit Agarwal, Commented Oct 22, 2018 at 6:50
Don't pass end date while saving new data

Sunil Patel
– Sunil Patel

2018-10-22 07:08:58 +00:00
Commented Oct 22, 2018 at 7:08 — Sunil Patel
– Sunil Patel, Commented Oct 22, 2018 at 7:08

Jack · Accepted Answer · 2020-09-14 13:23:44Z

6

It looks like you are trying to save the schema with an invalid endDate.

If you do not want to save a date simply leave it out from the object. For instance all you need to provide for your schema at a minimum is:

const newMail = mail.create({
    globalId: "1234",
    from: "Jack",
    beginDate: new Date(),
    subject: "Random subject",
});

If you tried to do something like,

endDate: null

this will fail as it is expecting a Date() object or nothing at all.

edited Sep 14, 2020 at 13:23

answered Oct 22, 2018 at 7:37

Jack

3,06711 gold badges51 silver badges70 bronze badges

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

Comments

Hardik Shah · Accepted Answer · 2018-10-22 08:19:33Z

As you have mentioned that you are storing endDate as null as String. That will definitely fail because your schema expecting a date and you are storing String.

Multiple ways you can approach:

Avoid endDate from JSON object. (You will not have endDate key in MongoDB)
set endDate: undefined that will automatically be ignored. (You will not have endDate key in MongoDB)
Set endDate: null not in String (You will have endDate key as null value)

Below one will not work:

var testObj = {
    ct: "null", // null as String value
    name: "Foo"
}

But this one will definitely work:

var testObj = {
    ct: null, // null as value
    name: "Foo"
}

Tested on below version:

MongoDB v3.2.18
Mongoose v4.10.8

Another point I want to add here is storing key: null will consume resources. If your requirement is not dependent on null values, I would like to use not to store a key in the database rather storing as null.

Michelangelo · Accepted Answer · 2019-09-27 13:06:50Z

1

I have solved this by setting the default date to undefined. It will not show up on creation of your object. That is fine as it is now a frontend problem. If a key does not exist the frontend will default to undefined. If it remains undefined it will not be saved in your database. Avoid having a default null I have made that mistake too!

mail = {
  endDate: {
   type: Date,
   default: undefined
  }
}

answered Sep 27, 2019 at 13:06

Michelangelo

5,9785 gold badges36 silver badges51 bronze badges

Comments

Utkarsh · Accepted Answer · 2022-04-22 03:34:06Z

0

In your schema you can mention the type as endDate : { type: Date || null} and wherever you feel like assign the value as null if date is not there OR you can even add default as null to schema.

answered Apr 22, 2022 at 3:34

Utkarsh

7359 silver badges15 bronze badges

Collectives™ on Stack Overflow

Mongodb insert null date

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related