how to do i get trunc day date

Question

i want to get the trunc date with such format :

20190326

this code in my schema :

 dateCreated: {
     
        type: Date,
        default: Date.now
    }

gives the following result :

2019-03-26T01:05:43.778Z

score 0 · Answer 1 · answered Mar 26 '19 at 05:19

0

Use Aggregation $dateToString

db.collection.aggregate([{
  $project: {
    date: {
      $dateToString: {
        format: "%d%m%Y",
        date: "$dateCreated"
      }
    }
  }
}])

You can set formate according to requirement. Sample data here.

answered Mar 26 '19 at 05:19

Ashok

2,846
1
12
20

thanks for your answer but i wanted to that within my schema. I solved it in a simpler way check my answer below – Salma Zaghloul Mar 26 '19 at 05:45
In your solution, you set the default value as string format(YYYYMMDD). And it is not a good way in mongoose On saving. – Ashok Mar 26 '19 at 06:21
do you have a better way so it can be done within my schema ? – Salma Zaghloul Mar 26 '19 at 06:56

score 0 · Answer 2 · answered Mar 26 '19 at 05:44

this solved it :

const date = new Date();
const today = date.getUTCFullYear().toString()+ (date.getUTCMonth()+1)+date.getUTCDate().toString();


export const taskSchema = new Schema ({
dateCreated: {
     
        type: String,
        default: today
    }
});

how to do i get trunc day date

2 Answers2