Javascript (MEAN Stack) - Dev Mode - why timestamp stored by Node.js shows different than the time of my laptop

Question

Kindly help with displaying correct datetime stamp.

E.g. Time on my Laptop: 02-Oct-2021 11:14am (this is in India)

Time stored by Node and Displayed in Angular 2021-10-02T05:44:09.022Z, i.e. 06:30 behind my time. And this is being executed in dev mode on localhost, so it should display my laptop's time right?

Here is the code in the Node.js while saving one comment.

  const comment = {
    comment: remarks,
    userName: user.userName,
    commentBy: user.employeeName,
    commentedOn: new Date()
  }

  clientDoc.commentsArr.push(comment)
  await clientDoc.save();

and here is the code in Angular template.

      <div *ngIf="clientDoc" class="container">
        <span class="subTitle">Existing Comments:</span>
        <table style="width: 100%">
          <tr *ngFor="let e of clientDoc?.commentsArr, let i =index">
            <span style="font-style: italic; font-weight: 500;">{{i + 1}}. {{e.commentBy}} ( {{e.commentedOn}} ) : </span>
            <span *ngIf="account.role !== 'Client'">
              <a class="link small" (click)="onEditRemarks(e._id, e.comment)">Edit</a>
            </span>
            <br>
            <span style="font-weight: 350;">{{e.comment}}</span>
          </tr>
        </table>
      </div>

And here is the timestamp stored in MongoDb

2021-10-02T05:44:09.022+00:00

I need to sort this both for the dev mode, as well as when I deploy this code on VPS - which is also in India.

Krushnasinh Jadeja · Accepted Answer · 2021-10-02 06:46:21Z

1

This happens because MongoDB always stores the timestamp in UTC.

Try below code:

var record = db.data.findOne();
var localNow = new Date( record.date.getTime() -  ( record.offset * 60000 ) );

For more reference, you can also check the MongoDB official Doc here

answered Oct 2, 2021 at 6:46

Krushnasinh Jadeja

6241 gold badge6 silver badges18 bronze badges

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

1 Comment

hemant Over a year ago

Thanks. I saw the MongoDB doc. But does that mean every time the offset needs to be saved and the dates need to be reconstructed for using both in Node as well as Angular. In Node - in case any date based calculations are to be performed with respect to date received from Angular. And in Angular every time date needs to be reconstructed to be displayed to the user? Isn't there any other way?

Collectives™ on Stack Overflow

Javascript (MEAN Stack) - Dev Mode - why timestamp stored by Node.js shows different than the time of my laptop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related