Javascript setting date for mongodb

Question

I'm trying to set my Date object in javascript, but I keep getting wrong date. This is how I set

var today = new Date();
var year = today.getFullYear();
var month = today.getMonth();
var day = today.getDate();
var hour = today.getHours();
var minute = today.getMinutes();
var second = today.getSeconds();

var create_date = new Date(year,month,day,0,0,0).toISOString();

My local datetime is 2015-11-17 21:00:00, however this creates 2015-11-16 22:00:00.000Z. If I use hour, minute and second variables in date constructor it creates the correct time in mongodb. I want to set date as 2015-11-17 00:00:00. What might be the problem?

Thank you

EDIT

Even the date is set correct in javascript, date in mongo db is seen as 2015-11-16 22:00:00.000Z

chridam · Accepted Answer · 2015-11-17 19:42:49Z

3

To set the date to the start of today, use the setHours() method of the Date object as follows:

var create_date = new Date();
create_date.setHours(0,0,0,0);
console.log(create_date); // prints Tue Nov 17 2015 00:00:00 GMT+0000 (GMT Standard Time)

For UTC, use setUTCHours():

create_date.setUTCHours(0,0,0,0);

edited Nov 17, 2015 at 19:42

answered Nov 17, 2015 at 19:14

chridam

104k26 gold badges246 silver badges243 bronze badges

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

2 Comments

Ahmet Tanakol Over a year ago

My document's date in mongodb is seen as 2015-11-16 22:00:00.000Z. However, console print is true. Why can't I just enter the same date into mongodb?

chridam Over a year ago

Try create_date.setUTCHours(0,0,0,0);

Collectives™ on Stack Overflow

Javascript setting date for 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